sql 18
获取当前薪水第二多的员工的emp_no以及其对应的薪水salary
http://www.nowcoder.com/questionTerminal/c1472daba75d4635b7f8540b837cc719
窗口函数解题
select a.emp_no,a.salary,a.last_name,a.first_name
from
(select e.emp_no,s.salary,e.last_name,e.first_name,
row_number()over( order by s.salary desc) as r
from employees e
inner join salaries s on e.emp_no=s.emp_no
where to_date='9999-01-01') a
where r=2
查看8道真题和解析
投递阿里巴巴等公司10个岗位