Re: rownum question
From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/02/12
Message-ID: <01bc1919$96264ae0$096fc589_at_RSNOWDEN.labinterlink.com>#1/1
Date: 1997/02/12
Message-ID: <01bc1919$96264ae0$096fc589_at_RSNOWDEN.labinterlink.com>#1/1
As I recall, the deal is this:
Rownum is evaluated after the row is fetched. When you say 'where rownum =
2',
the row is fetched, evaluated as being rownum =1, discarded as a
nonqualifier and then the next row fetched. It, too, is evaluated as
rownum=1, since no rows have yet satisfied the query. And so on...
Cute problem, eh?
Roger
> but, I CAN NOT do
>
> select * from table where rownum = 2;
> select * from table where rownum = 3;
Received on Wed Feb 12 1997 - 00:00:00 CET