Re: Get a row by it's number - Mailing list pgsql-novice

From Andrew McMillan
Subject Re: Get a row by it's number
Date
Msg-id 3976E0BC.C0327C29@catalyst.net.nz
Whole thread Raw
In response to Get a row by it's number  (Boszormenyi Laszlo <gcs@jupiter.hlab.uni-miskolc.hu>)
List pgsql-novice
Boszormenyi Laszlo wrote:
>
> Hello!
>
>  Is there any way to execute a select, and get only a specified row (let's
> say the third one)?

SELECT ..... LIMIT 1,3

From the documentation... postgresql-doc/html/user/sql-select.htm

 :-)

Cheers,
                    Andrew.
--
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267

pgsql-novice by date:

Previous
From: Phil Meadway
Date:
Subject: Re: Get a row by it's number
Next
From: Boszormenyi Laszlo
Date:
Subject: Get a row by it's number from (re)select