1、row_number 遇重复值排序不并列,连续不间断(递增或递减)排序
2、rank 遇重复值排序并列,然后跳跃到当前排序记录次数开始(递增或递减)排序
3、dense_rank 遇重复值排序并列,然后继续不间断(递增或递减)排序
select *,row_number () OVER ( ORDER BY testname desc) price FROM ISOPP where sno in('X30')
select *,RANK () OVER (ORDER BY testname desc) price FROM ISOPP where sno in('X30')
select *,dense_RANK () OVER ( ORDER BY testname desc) price FROM ISOPP where sno in('X30')