Skip to Content
0
Former Member
May 08, 2008 at 12:27 PM

Selecting Most Recent Record

174 Views

I need to create a query that selects the most recent record for an incident. Our ODS has multiple records for each incident ID. Each of these records has a different Last Changed date and I need to only include the most recent record in my query.

I'm stumped and don't quite know where to start. Any advice will be greatly appreciated.