i have employee table with 3 coloums
emp name companyname experience
1 1 3.5
2 2 4.0
1 1 2.6
2 2 3.0
3 3 5.0
i want the result table like this
emp name comany name experience
1 1 6.1
2 2 7.0
3 3 5.0
anyone tell me the sql query for this ?
sivak
-7
Junior Poster
Recommended Answers
Jump to PostWhat have you tried? You give no example code, so we have no information to help you with .. looks like a simple case of sorting and grouping to me.
Jump to Postselect unique or select distinct?
Jump to PostLooking at the numbers hes adding the results together.
All 11 Replies
LizR
171
Posting Virtuoso
ddanbe
2,724
Professional Procrastinator
Featured Poster
LizR
171
Posting Virtuoso
ddanbe
commented:
Well noticed with a fine eye!
+4
ddanbe
2,724
Professional Procrastinator
Featured Poster
LizR
171
Posting Virtuoso
rapture
134
Posting Whiz in Training
LizR
171
Posting Virtuoso
motin
0
Newbie Poster
Squirrel1984
0
Newbie Poster
sivak
-7
Junior Poster
LizR
171
Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.