Fetch Last 5 Records | Dataford Interview Questions

Write a SQL query to get the last 5 latest inserted records into the table.

Asked in the Technical round stage. Assume insertion recency is represented by inserted_at; when timestamps match, the higher record_id is considered later.

Output

Return columns record_id, record_name, and inserted_at.
Return exactly five rows, ordered from latest to earliest.
Place rows with NULL inserted_at after all timestamped rows.

Schema

records

Column	Type	Description
record_idPK	INT	Unique record identifier
record_name	VARCHAR(100)	Record label
inserted_at	TIMESTAMPTZ	Timestamp when the record was inserted

Your question is Fetch Last 5 Records. 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