1.分析
先查salary，按照salary分组并且降序排序取第二个。
再根据where条件中的salary值相等查询。

2.代码
SELECT emp_no, salary
FROM salaries
WHERE salary = (SELECT salary from salaries GROUP BY salary
ORDER by salary DESC LIMIT 1 OFFSET 1)