How do you add a rank from high to low? The RANK function defaults to low to high?

[APrasad_Tri]

Hi @Lisa M?,

The rank starts from 1 and increments. ?In the RANK() window function, we need to sort the columns. For sorting in descending order, use the '-' sign in front of the column value. This way you can assign a High rank to a low value.

For more information, please refer here

Hope this helps.

Best,

Apeksha Prasad

?