Re: Which is the best way to select the Nth row ?

Take a look at:

http://www.orafaq.org/faqsql.htm

which may help you out here.

Lee.

Francesco Marchioni wrote:

> Hello,
> I need a very simple task. A statement that SELECTS the Nth
> row from a table. Reading from manuals I cannot find a single
> statement to do it....as far as I understand you have to work with
> ROWID, issuing a few commands to achieve it, but I do hope there's a
 faster
> way
> to do it.....isn't there ?
> Thanks
> Francesco
>
>
>
  Received on Sat Dec 02 2000 - 13:19:07 CST