sql - Get latest updated records

Question

I have an "Observation" table in SQL Server 2008. This table has a locationId column for a bunch of geographic locations, a few columns for observation details and a column for latest updated date.

Every week, a new observation record for each location is appended. So a location has many occurrences in the table.

What I want to achieve is to be able to get the most recent observation record for each location.

Can anyone help with any idea?

Answer 1

 select * from observation where date=(select max(date) from observation)

or

select top 1 * from observation order by date desc