Any query??

[omegazafer]

Hi friends, I have below salesreport table, how can I get results of max sales of sales persons in one query? salesperson sales orderId Michele 120 120121 Guido 230 120122 Michele 300 120123 Michele 250 120124 Franco 100 120125 Guido 500 120126 Franco 400 120127 the query result must be; salesperson sales Michele 300 Guido 500 Franco 400

[Chris Meech]

select salesperson, max(sales) from salesreporttable group by salesperson

:wtf: :wtf: :wtf: :wtf: Did you use to work in sales?

Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]

[Paul Conrad]

Chris Meech wrote:

Did you use to work in sales?

:laugh::laugh::laugh:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

[GuyThiebaut]

Please do not post on multiple forums. I also answered your question on the C# forum. If I had looked at this forum first I would not have posted on the C# forum - so you wasted about 30 minutes of my time(well it was a pretty tough question :laugh: ). Guy

You always pass failure on the way to success.

[KANGAROO_]

plz dont laugh to anyone......he/she is member of our codeproject family.. :) :) :) :rose:

manoj Kumar Jha "Learn to smile at every situation. See it as an opportunity to prove your strength and ability."