题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
http://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
双重select聚合函数取max
select a.emp_no,b.salary,a.last_name,a.first_name
from employees a,salaries b
where a.emp_no=b.emp_no and b.salary=(
select max(salary)
from salaries
where salary not in (
select max(salary)
from salaries
)
);
查看35道真题和解析
