>I definitely dont fully understand ROWNUM yet,
>and you guys so far provided more info than a
>couple of books
>by Oracle, that I have here. For a second I thought
>I'm
>beginning to get it, but the queries suggested
>produced no results...
>
>
>SQL> SELECT ROWNUM, GENDER
> 2 FROM (SELECT RO
Each row that is retrieved from the database that matches the WHERE condition is
placed in a result set. The sequence within the result set is the value in the
pseudocolumn ROWNUM. If Oracle is using a full-table scan, the first row of the first
block is the first in the result set and is assign