[RESOLVED] Select Max Date

[wileyj]

I have some records in a table, where I want to grab the most recent date and the other data associated with it. It's so simple when I think about it, but I just can't seem to write SQL that does what I want. (this is SQL Server 2005, by the way).

Example.

I have Person1, Person2, and Person3. Each person has a distinct date associated with it. I want to grab the Person field along with the max date, but I don't want to group by, because it will list all 3 persons. Does that make sense?

Select Max(Date), Person From Person, it forces me to add a Group By Person, but then it lists all 3 Persons. It's annoying to say the least.

[GaryMazzone]

Select Person,Date From Person Where Date = (Select Max(Date) From Person)

[wileyj]

Yes, now I feel stupid. Thanks for the help!