根据某列进行排名

CREATE TABLE [dbo].[testTable]([UID] [int] NULL ,[Mark] [int] NULL) GOINSERT INTO dbo.testTable( UID, Mark )VALUES ( 1, 7 ),( 2, 3 ),( 2, 2 ),( 3, 4 ),( 4, 1 ),( 4, 8 ),( 4, 3 )GO SELECT uid ,total ,( SELECT COUNT(1) + 1FROM ( SELECT UID ,SUM(Mark) totalFROM dbo.testTableGROUP BY UID) bWHERE b.total > a.total) AS seqFROM ( SELECT UID ,SUM(Mark) totalFROM dbo.testTableGROUP BY UID) aORDER BY a.UID

结果如下

uid  total  seq
----------- ----------- -----------
1      7         2
2      5         3
3      4         4  
4     12        1