select emp_no,salary from salaries where salary = (select distinct(salary) from salaries order by salary desc limit 1,1) order by emp_no

SELECT emp_no, salary

FROM salaries

WHERE salary = (SELECT distinct(salary) FROM

salaries ORDER BY salary DESC LIMIT 1,1);