Question
How does DENSE_RANK differ from RANK?
Select an option. Your answer will be checked instantly.
Correct Answer: B. It gives ties the same rank without leaving gaps afterward
Explanation:
DENSE_RANK advances by one distinct ordered value.
Therefore the rank sequence remains consecutive after ties.
Leave a Reply