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
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
