题解 | #获取当前薪水第二多的员工信息
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
select
employees.emp_no,
salaries.salary,
employees.last_name,
employees.first_name
from
salaries,employees
where
salary < (
select
max(salary)
from
salaries
)
and salary >= all (
select
salary
from
salaries
where
salary < (
select
max(salary)
from
salaries
)
)
and salaries.emp_no = employees.emp_no
查看15道真题和解析
投递深圳市新凯来技术等公司10个岗位
