SQL17 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
描述
有一个薪水表salaries简况如下:
![](https://img2020.cnblogs.com/blog/1786811/202110/1786811-20211001174808162-954130471.png)
请你获取薪水第二多的员工的emp_no以及其对应的薪水salary
SELECT emp_no, salary FROM salaries WHERE to_date='9999-01-01' and salary = (SELECT salary FROM salaries WHERE to_date = '9999-01-01' GROUP BY salary ORDER BY salary DESC LIMIT 1,1 )