Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ROWNUM comparisons using < vs >

ROWNUM comparisons using < vs >

From: <Jim.Pickett_at_cubic.com>
Date: Wed, 20 Jan 1999 07:39:31 -0800
Message-ID: <Forum.916847048.12244.Pickett@ferret.corp.cubic.com>

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



#.12562GROVE
#003005BRASS
#006-10478
#025DRSCR
#51618100HSS
#51618100SCAPSS
#51618100SCS
#51618100SOCHD
#51618125H

9 rows selected.

SQL> select count(*) from part;

  COUNT(*)


     97392



  Jim Pickett
    Manager of Database Administration
    Cubic Corporation

  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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US