I have a table (tbl1) with fields (ID, date, description)
I would like to select the most recent record for each ID.
So for example if there are 5 records like this
ID | date | description
1 | 2010-05-18 | newest note
1 | 2010-05-17 | other note
1 | 2010-05-16 | oldest note
2 | 2010-05-17 | newest note
2 | 2010-05-16 | oldest note
I would like my query to return
1 2010-05-18 newest note
2 2010-05-17 newest note
I'm not sure how to combine 'Top' and 'distict' to get only the latest result for each unique id number. Thanks.