Latest Record Per User | Dataford Interview Questions

Given a list of records with user_id and event_time, write a query to keep only the latest record per user.

Use the records table. When a user has multiple records at the same latest timestamp, retain the record with the greatest record_id. Treat non-null timestamps as more recent than null timestamps.

Output

Return one row per user with record_id, user_id, and event_time.
Include each user's selected record, including users whose timestamps are all null.
Order by user_id ascending.

Schema

records

Column	Type	Description
record_idPK	INT	Unique identifier for the record
user_id	INT	Identifier of the user associated with the record
event_time	TIMESTAMP	Time when the user event occurred

Your question is Latest Record Per User. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem