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

注意：第二多，应该用倒序