Re: rownum question

From: Roger Snowden <rsnowden_at_IHateSpam.com>
Date: 1997/02/12
Message-ID: <01bc1919$96264ae0$096fc589@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 CST