2021-09-04
ran() over (order by ) ,dense_rank() over(order by ) ,qualify row_number()over(partition by columns1,columns2,3,4 order by columns desc,columns DESC)=1ran() over (order by ) :间断排序 例如:1,2,3,5,6,7dense_rank() over(order by ):连续排序 例如::1,2,2,3qualify
原创
2021-09-04 10:57:48 ·
129 阅读 ·
0 评论