Query only the latest values

[gundie]

I have the following in a table named "summary":

Company Date
ABC Auto 9/1/05
ABC Auto 8/17/05
ABC Auto 8/14/05
DEF Auto 4/1/05
DEF Auto 5/16/05
DEF Auto 7/22/05

I want to apply a query to this table to retrieve the latest date for each company. Result from the above table would be:

Company Date
ABC Auto 9/1/05
DEF Auto 7/22/05

How would I do that? Thanks for all help!

 

[flyover789]

SELECT Company, Max([Date]) AS Latest_Date
FROM summary
Group BY Company;

[red]You should avoid using reserved words (like "Date") as field names in your tables![/red]

HTH,
fly

[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Database_Systems and _Applications shared across all Business_Areas[/blue]

 

[PHV]

SELECT Company, Max([Date]) As LatestDate
FROM summary
GROUP BY Company

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gundie]

I'll try that, thanks to all!

 

[PHV]

Hey, Martin, You looked over my shoulder ? ;-)