Top N Records in SQL | Dataford Interview Questions

The TEKsystems staffing operations dashboard needs a short list of the highest-priority open requisitions for recruiter review. Write a PostgreSQL query to return the top 3 open requisitions based on their priority score.

Requirements

Include only rows where status is Open.
Return the requisition ID, role title, and priority score, ordered from highest to lowest priority. Return no more than three rows. For equal scores, sort by requisition_id ascending.

Schema

job_requisitions

Column	Type	Description
requisition_idPK	INT	Unique requisition identifier
role_title	VARCHAR(120)	Position title
status	VARCHAR(20)	Current requisition status
priority_score	INT	Numeric score used to prioritize recruiting work

Your question is Top N Records in SQL. 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

Requirements

Include only rows where status is Open.
Return the requisition ID, role title, and priority score, ordered from highest to lowest priority. Return no more than three rows. For equal scores, sort by requisition_id ascending.

Schema

job_requisitions

Column	Type	Description
requisition_idPK	INT	Unique requisition identifier
role_title	VARCHAR(120)	Position title
status	VARCHAR(20)	Current requisition status
priority_score	INT	Numeric score used to prioritize recruiting work

Your question is Top N Records in SQL. 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.