题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#

方法1:

SELECT t3.emp_no ,t3.salary from salaries t3
where t3.salary = ( SELECT t1.salary from salaries t1 GROUP BY t1.salary ORDER BY t1.salary desc LIMIT 1,1 )

方法2:

SELECT t3.emp_no ,t3.salary from salaries t3 where t3.salary = ( SELECT t2.salary from salaries t2 where t2.salary < ( SELECT max(t1.salary) from salaries t1 ) ORDER BY t2.salary desc limit 1 )