SQL for Second Largest Value | Dataford Interview Questions

Teradata uses employee compensation data to support workforce analysis. Write a PostgreSQL query to identify employees earning the second highest distinct salary among currently active employees.

Requirements

Consider only rows where employment_status = 'Active'.
Rank distinct salary values from highest to lowest, handling duplicate salaries correctly.
Return every active employee whose salary has rank 2, including employee_id, employee_name, and salary.
Exclude employees with a NULL salary from consideration and order the results by employee_id.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(12,2)	Annual employee salary
employment_status	VARCHAR(20)	Current employment status

Your question is SQL for Second Largest Value. 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

Teradata uses employee compensation data to support workforce analysis. Write a PostgreSQL query to identify employees earning the second highest distinct salary among currently active employees.

Requirements

Consider only rows where employment_status = 'Active'.
Rank distinct salary values from highest to lowest, handling duplicate salaries correctly.
Return every active employee whose salary has rank 2, including employee_id, employee_name, and salary.
Exclude employees with a NULL salary from consideration and order the results by employee_id.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(12,2)	Annual employee salary
employment_status	VARCHAR(20)	Current employment status

Your question is SQL for Second Largest Value. 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.