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 ?
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.
I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but ...