K-th Highest Salary With DENSE_RANK | Dataford Interview Questions

Write a SQL query using window functions (DENSE_RANK) to retrieve the K-th highest employee salary while properly handling duplicate values.

For this exercise, use K = 3. Exclude employees whose salary is NULL, and include the department name when available.

Output

One row per employee earning the third-highest distinct salary.
Return employee_id, employee_name, salary, department_name, and salary_rank.
Sort by salary descending, then employee_id ascending.

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INTEGER	Referenced department identifier
salary	NUMERIC(12,2)	Annual employee salary

departments

Column	Type	Description
department_idPK	INTEGER	Unique department identifier
department_name	VARCHAR(100)	Department name

Your question is K-th Highest Salary With DENSE_RANK. Start with the requirements and the two tables 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.