I would like some advice on the various and best ways of finding the rank of the
row which satisfies a given condition in a rsult set.
Let's assume that the result set includes a field containing an identifier from
one of the table used in the query and that not two rows have the same value
for this identifier but that the result set does not contains all the
sequential values for this identifier and/or the values are not sorted in any
The brute force method is to loop through all the rows of the result set, until
the number is found to get the rank of the row. That does not seem very clever
and it can be very time consuming if the set has a lot of rows.