SQL Server添加序号列

2012-08-15 09:17:32     我来说两句      

收藏    我要投稿

SQL Server添加序号列

 

select ROW_NUMBER() OVER(ORDER BY Convey_Fee desc) as z,

rank() OVER(ORDER BY Convey_Fee desc) as z,

DENSE_RANK() OVER(ORDER BY Convey_Fee desc) as z,

NTILE(4) OVER(ORDER BY Convey_Fee desc) as z,

(select sum(1) from Consign_D where Convey_Fee<=a.Convey_Fee) num,

(select sum(1) from Consign_D where Convey_Fee<a.Convey_Fee) num1,Convey_Fee from Consign_D a order by Convey_Fee desc

 结果：  www.2cto.com  

 

 

 

作者 飛雲若雪