ROW_NUMBER vs RANK vs DENSE_RANK vs NTILE — what is the difference?

Answer preview

All four are ranking window functions that differ only in how they handle ties: ROW_NUMBER never ties, RANK ties then skips numbers, DENSE_RANK ties without gaps, and NTILE(n) ignores tie semantics and just distributes rows into n buckets.…