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;