题解 | 升序降序排名I
升序降序排名I
https://www.nowcoder.com/practice/b260265671c54882ac462bf4b5644bd9
select *,rank()over(partition by 部门编号 order by 薪水) as 薪水升序排名, rank()over(partition by 部门编号 order by 薪水 desc) as 薪水降序排名 from 薪水表
升序降序排名I
https://www.nowcoder.com/practice/b260265671c54882ac462bf4b5644bd9
select *,rank()over(partition by 部门编号 order by 薪水) as 薪水升序排名, rank()over(partition by 部门编号 order by 薪水 desc) as 薪水降序排名 from 薪水表
相关推荐