Top N Records in SQL

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is Top N Records in SQL. Start with the requirements and the one table on the right.

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

You need to log in / sign up to run or submit.

Problem

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

Tablesjob_requisitions

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results