When you apply both a sort and a rank to
the same row or column, the returned data reflects both operations. The values
are ranked, and ordered based on the explicit sort operation. If you then
remove either the sort or the rank, the remaining operation is reapplied to the
query's entire data set.
When you apply a sort and a rank to the
same member, the explicitly applied sort always overrides the sort applied by
the ranking operation.