ROW_NUMBER() vs RANK() vs DENSE_RANK()

The RANK, DENSE_RANK and ROW_NUMBER functions are used to return an increasing integer number. All of these three functions require the ORDER BY clause to function in the way intended. Before explaining how these functions work, let's understand how...