SQL17 获取当前薪水第二多的员工的emp_no以及其对应的薪水sal

题目地址：
https://www.nowcoder.com/practice/8d2c290cc4e24403b98ca82ce45d04db?tpId=82&&tqId=29769&rp=1&ru=/ta/sql&qru=/ta/sql/question-ranking

求薪水第二高，使用子查询，子查询查找

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

不用子查询

select emp_no, salary from salaries
order by salary desc limit 1, 1