Re: sql limitation?

here are some hints:

use nested queries
use rownum
use order by

"outer most" query:

select <blah>
from (subqueries which produce rownum as my_rownum) where my_rownum = 10

"Fabre" <Emmanuel.Fabre_at_tangensys.com> wrote in message news:55d558a7.0110310501.af61dc7_at_posting.google.com...
> Hi,
>
> What is the efficient way to select the 10th row in a table?
> Let's assume, there is no way to select it directly.
> At the moment, I do not see how to avoid to select (and
> fetch depending on the treatment) the first 9 rows.
> Probably, it makes no sense from an sql point of view?
>
> Thanks in advance,
> Emmanuel
Received on Wed Nov 07 2001 - 01:17:17 CET