RANK VS DENSE_RANK VS ROW_NUMBER

 

Key Differences:

1. ROW_NUMBER(): Assigns a unique, sequential number to each row, even if there are ties.
2. RANK(): Assigns the same rank to rows with the same value, but it leaves gaps in the sequence for tied rows.