<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
>
When the 1st row is returned its ROWNUM is 1 & 1 <> 2 so it is NOT retained.
When the next row is returned itsROWNUM is 1 (because no previous rows
are/were accepted AND 1 <> 2. etc.....
Received on Mon Jan 03 2005 - 19:00:03 CST
