순위함수(ROW_NUMBER, DENSE_RANK,RANK)
- row_number : 1,2,3,4,... 번호를 부여 select row_number() over (partition by 컬럼명, order by컬럼명, .. as 별칭 from 테이블 명 (partition by 컬럼명은 생략가능 (=group by) (order by 생략 불가) 1) partition by 생략 2) partition by 포함 select row_number() over(partition by CustomerAddr order by CustomerAge desc) as you, CustomerName, CustomerId, CustomerAddr, CustomerAge from Customer; - dense_rank() : 비교값이 동일할 때 같은 번호를 부여 1, 2,..
2022. 10. 25.