Scenario SQL Question
Find the Nth Highest Salary Across All Departments
Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.
Problem Statement
Find every employee whose salary equals the 4th HIGHEST distinct salary — not just one. Use DENSE_RANK so the answer correctly captures everyone tied at that salary tier. Show first_name, last_name, salary, ordered by employee_id.
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: