Re: Get a row by it's number

By definition, relation database tables are unordered. This is because the
storage characteristics can change (say from ISAM to BTREE or HASH indexing)
without affecting the data content.  Do you want to retrieve the nth row from
a select ... order by statement? Or are you looking for the nth row added? Nth
row added can be achieved if you use an incrementing sequence counter when
adding.

Boszormenyi Laszlo wrote:

> Hello!
>
>  Is there any way to execute a select, and get only a specified row (let's
> say the third one)?
>
> Thanks in advance,
>         Laszlo Boszormenyi

--
Phil Meadway                          Tel.: +(44) 1444 892 274
Managing Director                     philip.meadway@esmltd.co.uk
Enterprise Systems Management Limited www.esmltd.co.uk