I'm disappointed. I've been doing this for a while with ROW_NUMBER and PARTION and it works gr8 in all the situations I've come across.

I can't figure out what advantage I can gain using the RANK function.

I'm not sure there is an advantage, but I'll be happy if someone corrects me 🙂