SQL 에서 순위를 할당하는 함수

ROW_NUMBER() OVER ( [PARTITION BY A1 [, A2, ...] ] ORDER BY { B1 [DESC] [, B2 [DESC], ...] } )
RANK()              OVER ( [PARTITION BY A1 [, A2, ...] ] ORDER BY { B1 [DESC] [, B2 [DESC], ...] } )
DENSE_RANK()  OVER ( [PARTITION BY A1 [, A2, ...] ] ORDER BY { B1 [DESC] [, B2 [DESC], ...] } )

ROW_NUMBER() 함수 사용 예>

SELECT ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, Name, Score FROM TBL_USER

RANK() 함수 사용 예>

SELECT RANK() OVER (ORDER BY Score DESC) AS Rank, Name, Score FROM TBL_USER

DENSE_RANK() 함수 사용 예>

SELECT DENSE_RANK() OVER (ORDER BY Score DESC) AS Rank, Name, Score FROM TBL_USER