Menu

As the names suggest, they can be used to rank. They are useful for a use case such as finding the top customer or second, or third customer of each salesperson.

RANK

In case of Jack, we can see that RANK returned 1, 1, and 3. But that probably should have been two? If that’s the case…

DENSE_RANK

So, if we wanted to see the customer with highest sales.