牛客150668110号

分类

题解(2)

/ 注册

全部文章（共2篇）

查找当前薪水排名第二多的员工，不使用order by完成

SELECT employees.emp_no, salaries.salary, employees.last_name, employees.first_name FROM employees JOIN salaries ON employees.emp_no = salaries.emp_no...

2020-12-28

0 370

薪水第二多的员工

SELECT s1.emp_no, s1.salary FROM salaries AS s1 JOIN (SELECT salary FROM salaries WHERE to_date='9999-01-01' GROUP BY salary ORDER...

2020-12-28

0 419