Re: rownum

From: Snewber <s_at_s.com>
Date: Tue, 4 Jan 2005 11:04:52 +1000
Message-ID: <crcq3n$u4v$1@bunyip.cc.uq.edu.au>

Have a play around with the following query.

select num, username, rownum from (

    select rownum num, username
    from dba_users
    order by username
    )
where num < 10;

<db2group88_at_yahoo.com> wrote in message news:1104798968.224923.182020_at_z14g2000cwz.googlegroups.com...
> hi, we are using oracle 10g, here is the wierd thing i don't
> understand, i do "select rownum, name from admin.test", i can see the
> result value of rownum is 1 and 2, and both columns has data in it, but
> when i do "select name from admin.test where rownum=2", i can't get the
> data back, i do "select name from admin.test where rownum=1", the data
> is returned, can someone help me? thanks
>
Received on Mon Jan 03 2005 - 19:04:52 CST