Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> rownum question
Hi,
I was able to do
select * from table where rownum = 1;
select * from table where rownum <= 20;
update table
set id = rownum;
but, I CAN NOT do
select * from table where rownum = 2;
select * from table where rownum = 3;
...
Can someone tell me why?
Thanks,
Phil Tsao Received on Wed Jan 29 1997 - 00:00:00 CST