Finding Most recent date

[greese]

I have a table of people who move rooms. Every time they change rooms, the room gets updated along with a transfer date.

I am trying make a query that will return only the record with the most recent transfer date.

Can anyone point me in the right direction?

Thanks!

Greg

 

[cLFlaVA]

SELECT TOP 1 * FROM table_name ORDER BY date_column DESC

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!

 

[rp1504]

Select MAX(Transfer_Date) Last_Transfer
From Rooms_Table