I also generally use a partitioned row_number(), ordering on some selection criteria (highest number of x with provider y, etc).

Is the output of Rank defined by ANSI to always support...