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.