如何为此SQL查询添加行号？

Question

我有这个Server 2008 R2查询

SELECT TOP(10)
    *
FROM 
    [T1].dbo.CPU_Benchmarks 
JOIN 
    [T1].dbo.CPU_Slugs ON CPU_Benchmarks.Id = [T1].dbo.CPU_Slugs.BenchmarkId 
                       AND [Approved] = 'true')
ORDER BY 
     [T1].dbo.[CPU_Benchmarks].Overal_Score DESC

Answer 1

SELECT TOP (10)  
    row_number() over (order by [T1].dbo.[CPU_Benchmarks].Overal_Score DESC) as rn, *
FROM [T1].dbo.CPU_Benchmarks
JOIN [T1].dbo.CPU_Slugs 
   ON CPU_Benchmarks.Id = [T1].dbo.CPU_Slugs.BenchmarkId
  AND [Approved] = 'true'
ORDER BY 
     [T1].dbo.[CPU_Benchmarks].Overal_Score DESC

Answer 2

SELECT row_number() over(ORDER BY [T1].dbo.[CPU_Benchmarks].Overal_Score DESC) as rn, *
FROM [T1].dbo.CPU_Benchmarks 
JOIN [T1].dbo.CPU_Slugs ON CPU_Benchmarks.Id=[T1].dbo.CPU_Slugs.BenchmarkId 
AND [Approved]='true'

您可以使用row_number函数。