Intermediate · SQL · Window functions

Third-highest distinct salary with DENSE_RANK

Commonly asked: Extremely common follow-up to second-highest salary · ~8 min

Return the name and salary of every employee earning the **third-highest distinct** salary, using a window function.