rownum question
From: <ptsao_at_sequeltech.com>
Date: 1997/01/29
Message-ID: <32EFD1DB.A7D_at_sequeltech.com>#1/1
Date: 1997/01/29
Message-ID: <32EFD1DB.A7D_at_sequeltech.com>#1/1
Hi,
[Quoted] I was able to do
[Quoted] [Quoted] 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 CET