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

Ask yourself what it means to get
'the Nth row in a table'. This may give
you a clue about the most appropriate
approach for __your__ requirement.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Francesco Marchioni wrote in message
<908aeg$qs0$1_at_marte.lastminutetour.com>...


>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

>

>

>