Certainly one of the options we have would be to make the most of the rownum pseudocolumn. It is a selection that is assigned to a row when it truly is retrieved from the resource desk, and something which is vital to know, is the fact whether it is Employed in a question that has an ORDER BY clause, this number is assigned prior to the rows are or