select emp_no, salary

from salaries

where salary = (select salary from salaries group by salary order by salary desc limit 1,1);

# SELECT emp_no, salary

# FROM salaries

# WHERE salary = (SELECT MAX(salary) FROM salaries WHERE salary < (SELECT MAX(salary) FROM salaries))