窗口函数+子查询解决。
select emp_no,salary
from (
select emp_no,salary,rank()over(order by salary desc ) r
from salaries
) new
where new.r=2
order by emp_no
select emp_no,salary
from (
select emp_no,salary,rank()over(order by salary desc ) r
from salaries
) new
where new.r=2
order by emp_no
「求助大佬帮看看这道算法题吧!」有一个薪水表salaries简况如下: emp_no salary from_date to_date 10001 88958 2002-06-22 9999-...
https://gw-c.nowcoder.com/api/sparta/jump/link?link=https%3A%2F%2Fwww.nowcoder.com%2Fpractice%2F8d2c290cc4e24403b98ca82ce45d04db
全部评论
相关推荐

点赞 评论 收藏
分享
点赞 评论 收藏
分享