题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
with t_salary as (select t1.emp_no, t2.salary, t1.last_name, t1.first_name from( select * from employees where emp_no !=( select emp_no from salaries where salary = (select max(salary) from salaries))) as t1 left join salaries as t2 on t1.emp_no = t2.emp_no) select * from t_salary where salary = (select max(salary) from t_salary);
Momenta公司福利 615人发布
投递腾讯等公司10个岗位