Amongst the choices we have is to employ the rownum pseudocolumn. This is the range that is assigned to a row when it really is retrieved from the supply desk, and something that is vital to know, is that whether it is Employed in a question which has an ORDER BY clause, this number is assigned before the rows are ordered, and that is why it can't