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