I want my row numbers to come up as 1,2,2,2,3 while using a ranking function. Which ranking function should I use?
ROW_NUMBER()
RANK()
DENSE_RANK()
NTILE(integer_expression)