row_number()over() 和 rank()over()的区别

分类: 文章 • 2024-08-20 16:26:34

select employee.*,row_number()over(partition by deptid order by salary desc) rank from employee;

row_number()over() 和 rank()over()的区别
select employee.*,rank()over(partition by deptid order by salary desc) rank from employee;