컴퓨터/프로그래밍
SQL 에서 순위를 할당하는 함수
jungtae17
2012. 3. 3. 22:00
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], ...] } )
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