StackOverflowDocumentation
.dbo
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
usp_Q6772
Parameters
Name
Type
Mode
@UserId
int
IN
Definition
CREATE PROC [dbo].[usp_Q6772] @UserId INT AS BEGIN /* Source: http://data.stackexchange.com/stackoverflow/query/6772/stackoverflow-rank-and-percentile */ WITH Rankings AS ( SELECT Id, Ranking = ROW_NUMBER() OVER(ORDER BY Reputation DESC) FROM Users ) ,Counts AS ( SELECT Count = COUNT(*) FROM Users WHERE Reputation > 100 ) SELECT Id, Ranking, CAST(Ranking AS decimal(20, 5)) / (SELECT Count FROM Counts) AS Percentile FROM Rankings WHERE Id = @UserId END