[ORACLE] RANK() OVER (PARTITION BY 컬럼 ORDER BY 컬럼)
Purpose RANK calculates the rank of a value in a group of values. The return type is NUMBER. Examples SELECT 성명 , 과목 , 점수 , RANK() OVER( PARTITION BY 성명 ORDER BY 점수 DESC ) RNUM FROM ( SELECT '홍길동' 성명, '수학' 과목 , 55 점수 FROM DUAL UNION ALL SELECT '홍길동' 성명, '영어' 과목 , 60 점수 FROM DUAL UNION ALL SELECT '홍길동' 성명, '국어' 과목 , 96 점수 FROM DUAL UNION ALL SELECT '홍길동' 성명, '과학' 과목 , 87 점수 FROM DUAL )
2009. 10. 27.