diff between dense rank and rank?
Answers
Answered by
1
RANK: This gives you the ranking within your ordered partition. Ties are assigned the same rank, with the next ranking(s) skipped. ...
DENSE RANK: This gives you the ranking within your ordered partition, but the ranks are consecutive in it. Also, no ranks are skipped if there are ranks with multiple items.
Answered by
2
RANK: This gives you the ranking within your ordered partition. Ties are assigned the same rank, with the next ranking(s) skipped.
DENSE RANK: This gives you the ranking within your ordered partition, but the ranks are consecutive in it. Also, no ranks are skipped if there are ranks with multiple items.
Hope it helps.
Similar questions