Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ROWNUM comparisons using < vs >
Greetings Gurus -
Why is it that I can use the pseudo-column ROWNUM to get row/columns less than a given ROWNUM value but I can't use it to get row/columns greater than a given ROWNUM value ?
Example from the table below has +97000 rows :
SQL> select part_nbr from part where rownum > 10; no rows selected
SQL> select part_nbr from part where rownum < 10;
PART_NBR
9 rows selected.
SQL> select count(*) from part;
COUNT(*)
97392
Work: (619)505-2868
Pager: (619)494-5539
E-mail: jim_pickett_at_cubic.com
01/20/1999 07:39:31 ======================================Received on Wed Jan 20 1999 - 09:39:31 CST