Need help in building this query... 2

[thelordoftherings]

Hello,

I have a table containing this sort of a data:

ID DATE
123 1/1/2005
456 1/4/2006
123 7/5/2005
789 11/10/2002
789 6/7/2001
123 1/12/2003
....

I would like to create a query which will output for each ID it's latest date available. For example, for the data above the query results will be:
123 7/5/2005
456 1/4/2006
789 11/10/2002
...

Can anyone please help me build such a query?

 

[gmmastros]

Select ID, MAx(Date)
From Table
Group By ID
Order By Id

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bborissov]

SELECT Id, MAX(Date) AS Date
FROM MyTable
GROUP BY Id

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[thelordoftherings]

10X alot for both of you!