17.获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
题目内容:
代码及思路:
因为输出是薪水第二多的员工,因此又涉及到ORDER BY ,DESC 和LIMIT的用法了,详见之前的题目
SELECT emp_no,salary FROM salaries
WHERE to_date='9999-01-01'
ORDER BY salary DESC LIMIT 1,1;
17.获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
题目内容:
代码及思路:
因为输出是薪水第二多的员工,因此又涉及到ORDER BY ,DESC 和LIMIT的用法了,详见之前的题目
SELECT emp_no,salary FROM salaries
WHERE to_date='9999-01-01'
ORDER BY salary DESC LIMIT 1,1;