 |  |  |  |  |  |  |  |
sql
Please support our C# advertiser: Intel Parallel Studio Home
 |
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 ?
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 ?
What 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.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Oct 2008
Posts: 1,984
Reputation: 
Solved Threads: 289
select unique or select distinct?
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
Looking at the numbers hes adding the results together.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Oct 2008
Posts: 1,984
Reputation:
Solved Threads: 289
Yeah LizR, remarkable sight you have!
select sum(experience) from table... where...?
select sum(experience) from table... where...?
Today is a gift, that's why it is called "The Present".
Make love, no war. Cave ab homine unius libri.
Danny
Make love, no war. Cave ab homine unius libri.
Danny
Well Ive given some big hints up earlier too.. but yes, the SQL for it should be a real simple 1 line uncomplex answer.. Im interested to see what the original posters tried so far.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Jul 2007
Posts: 276
Reputation:
Solved Threads: 37
Posting Whiz in Training
That wasn't easy for me to see and if you hadn't pointed it out I don't know if I would have caught it.
how in the world did you see that randomly?
how in the world did you see that randomly?
Because to me its obvious 
- Im that odd.
Of course it would help if the initial poster could define their requirements in proper terms it would help them help themselves.
Far too many posts are a bunch almost nonsensical jabberings and with a final comment of all but "code please" .. if you cant define clearly what you want, its highly likely you wont be able to code it either.
- Im that odd.Of course it would help if the initial poster could define their requirements in proper terms it would help them help themselves.
Far too many posts are a bunch almost nonsensical jabberings and with a final comment of all but "code please" .. if you cant define clearly what you want, its highly likely you wont be able to code it either.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
|
Similar Threads
- ASP.NET/SQL Developer/Programmer (Web Development Job Offers)
- Freelance .NET / MS SQL developer (Web Development Job Offers)
- Software Engineer (.NET , SQL) (Software Development Job Offers)
- UPS is Hiring!! PL/SQL & UNIX Technical Specialist (Software Development Job Offers)
- SQL Server DBA - " Hot " (Software Development Job Offers)
- PHP / My SQL Web developer (Web Development Job Offers)
- Sql Dba (Software Development Job Offers)
- SQL Server DBA (Software Development Job Offers)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
Other Threads in the C# Forum
- Previous Thread: Combo Box
- Next Thread: the "this" reference & indexers
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net access ado.net algorithm array barchart bitmap box broadcast buttons c# chat check checkbox client color combobox concurrency control conversion csharp custom database datagrid datagridview dataset datetime degrees development draganddrop drawing encryption enum event excel file files form format forms function gdi+ globalization httpwebrequest image index input install java label list listbox listener mandelbrot math microsoftc#visualexpress mouseclick mysql networking operator path photoshop picturebox pixelinversion post prime programming radians regex remote remoting richtextbox save saving serialization server sleep socket sql statistics stream string table tcp text textbox thread time timer treeview update usercontrol validation view visualstudio webbrowser windows winforms wpf xml
