Dense_Rank(), Row_Number(), Rank() in sql server
摘要：
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 ranksfrom dbo.dense_demoselect * from dbo.dense_demoget the below result: 阅读全文
posted @ 2013-05-01 00:23 shcity 阅读(192) 评论(0) 推荐(0) 编辑
