Re: Question: Finding the nth row in a table

On Tue, 25 Nov 1997 13:22:18 -0800, "David Russell" <user_at_msn.com> wrote:

>I am afraid that this is not strictly true, ROWNUM is caculated from the
>row source, before any sorting occurs. This means if you use ROWNUM in
>queries that perform sorts the results will be inconsistent.

I had written the follwing:

>> select whatever from atable where rownum=n oder by whatever;

As others have already stated I made a wrong statement. The above select won't work. It would have been nice, but ...

Sorry for the mistake. I was too quick to answer and should have thought before. :-(

Heber

---
hferraz_at_via.at