Interview Lab
SQL Interview
The SQL questions that come up again and again.
What is the difference between RANK, DENSE_RANK and ROW_NUMBER?
They differ only in how they handle ties: ROW_NUMBER never ties, RANK ties and skips, DENSE_RANK ties and does not skip.
BEGINNERDifficulty: BEGINNERWindow functions