[DUG] sql - GROUP

[John C]

Hi all

 

Can anybody help me with the following query?

 

I have a table like:

 

ItemID             Name              Number

234                  Washer            100

234                  Washer            120

234                  Washer            105

 

500                  Nut                  520

500                  Nut                  502

500                  Nut                  501

 

What I would like to see is a for each ItemID the highest Number sorted by
Name.

My sql is like:

 

SELECT *

FROM Table

GROUP BY ItemID

ORDER BY Name, Number

 

What returns is:

ItemID             Name              Number

234                  Washer            105

500                  Nut                  501

 

It seems to return the last record for each item. How can I get the highest
number for each Item?

 

Thanks a lot for any help.

John C

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20131110/d680fef5/attachment.html