Amazon interview question
4. Find the second highest earner
Interview Answer
Anonymous
23 Jun 2025
WITH SalaryRanks AS ( SELECT name, salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS salary_rank FROM employees ) SELECT name, salary FROM SalaryRanks WHERE salary_rank = 2;