SELECT emp_no, salary
FROM salaries
WHERE salary = (SELECT DISTINCT salary
FROM salaries
ORDER BY salary DESC
LIMIT 1 OFFSET 1);

SELECT emp_no, salary
FROM salaries
WHERE salary = (SELECT DISTINCT salary
FROM salaries
ORDER BY salary DESC
LIMIT 1 OFFSET 1);