I know those clauses but I can't see how they would help me get the numeric rank of a given row or value efficiently.