1
SQLAdvanced#windows
SQLAdvanced#windows
Difference between ROW_NUMBER, RANK and DENSE_RANK?
ROW_NUMBER always gives unique consecutive numbers. RANK gives ties the same rank and then skips numbers. DENSE_RANK gives ties the same rank with no gaps.
Example
-- salaries 500, 500, 400 ROW_NUMBER -> 1, 2, 3 RANK -> 1, 1, 3 DENSE_RANK -> 1, 1, 2