Skip site navigation (1) Skip section navigation (2)

Re: Get a row by it's number

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Boszormenyi LaszloDate: 2000-07-20 11:30:55
Subject: Get a row by it's number from (re)select
Previous:From: Phil MeadwayDate: 2000-07-20 10:59:49
Subject: Re: Get a row by it's number

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group