SQL practice › Window functions
Third Highest Distinct Salary
Hard · Window functions
Return a single value: the 3rd highest distinct salary (if two people share a salary, it counts once).
Hint
DENSE_RANK() does not skip numbers after ties.
Write your query on this page — it runs against the sample company database in your browser and is checked instantly.
Next problem: Repeat Customers