Data/Data Analysis
2020. 8. 5.
[SQL] RANK(), ROW_NUMBER(), DENSE_RANK()
RANK() 함수는 중복 순위 다음은 해당 개수만큼 건너뛰고 반환 예를들어서 다음과 같은 A테이블이 있다하면 pay user 4.00A3.00 B 3.00C2.00 D select rank() over(order by pay desc) as rank, pay, user from A 다음과 같이 출력이된다 rank pay user 1 4.00A23.00 B 2 3.00C42.00 D ROW_NUMBER() 함수는 중복 순위 상관없이 순차적으로 반환 select row_number() over(order by pay desc) as rank, pay, user from A rank pay user 1 4.00A23.00 B 3 3.00C42.00 D DENS..
![[SQL] RANK(), ROW_NUMBER(), DENSE_RANK()](http://i1.daumcdn.net/thumb/C480x320/?fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FlHxpf%2FbtqGexxF7gV%2FAAAAAAAAAAAAAAAAAAAAAHSj8gAqS54YOOmzIrZoDRNSx3YGXgQzrEZFPHSLKQ-V%2Fimg.jpg%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1759244399%26allow_ip%3D%26allow_referer%3D%26signature%3Df3%252BK3V1uo33CscowvbCCs%252BjlsLo%253D)