题解 | 获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
https://www.nowcoder.com/practice/c1472daba75d4635b7f8540b837cc719
select em.emp_no,so.salary,em.last_name,em.first_name from employees em join salaries so on em.emp_no=so.emp_no where so.salary=( select max(salary) from salaries where salary < ( select max(salary) from salaries) );
查看10道真题和解析