select id,number,name ,DENSE_RANK() over(partition by number order by name ) as dense ,row_number() over(partition by number order by name ) as rownumber ,rank() over(partition by number order by name ) as ranks from dbo.dense_demo select * from dbo.dense_demo
get the below result:
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。