2006年10月20日

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, (selec... 阅读全文

posted @ 2006-10-20 17:56 天下 阅读(28644) 评论(2) 推荐(4)

导航