Difference between Rank and Dense rank function?

Question

Accepted Answer

Rank function assigns unique rank to each distinct row, while Dense rank function assigns same rank to rows with same values.

Rank function is used to assign a unique rank to each distinct row based on the order specified in the ORDER BY clause.
Dense rank function is used to assign the same rank to rows with the same values, skipping the next rank if there are ties.
Rank function returns consecutive ranks, while dense rank function returns consecutive ranks with no gaps.
Rank function is used with the RANK keyword, while dense rank function is used with the DENSE_RANK keyword.
Example: If there are two rows with the same value and rank 2, rank function will assign rank 3 to the next row, while dense rank function will assign rank 2 to the next row.

Top Saras Analytics Data Analyst interview questions & answers