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

In relational database theory, there is no such thing as the Nth row of a table. This is becuase there is no *order* to the rows in a relational table. Since relational database theory does not define the Nth row in a table, you will not find a simple SELECT statement which returns this row.

HTH,Brian

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
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================