From: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Boszormenyi Laszlo <gcs(at)jupiter(dot)hlab(dot)uni-miskolc(dot)hu> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Get a row by it's number |
Date: | 2000-07-20 11:21:32 |
Message-ID: | 3976E0BC.C0327C29@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)cat-it(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Boszormenyi Laszlo | 2000-07-20 11:30:55 | Get a row by it's number from (re)select |
Previous Message | Phil Meadway | 2000-07-20 10:59:49 | Re: Get a row by it's number |