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

Re: Question about restricting the number of rows

From: Mo Holkar <pgsql(at)digitalmindgames(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question about restricting the number of rows
Date: 2002-02-20 21:05:43
Message-ID: 5.1.0.14.2.20020220205546.04d59010@pop.ntlworld.com (view raw or flat)
Thread:
Lists: pgsql-novice
At 20:03 20/02/02, Steve wrote:


>Hi,
>
>If I am running a query I know could return 1000's of rows;
>is there a PG way to say to just return the first, say, 50 rows?

Like this:

SELECT * FROM table LIMIT 50;

If you wanted rows 51-100 you'd use

SELECT * FROM table LIMIT 50 OFFSET 50;

and in general LIMIT n OFFSET m will return rows from m+1 to m+n inclusive.

Bear in mind though that for 'the first 50' to be meaningful you'll likely 
have to be using an ORDER BY clause.

best,

Mo




Mo Holkar
Digital Mind Games -- log on to take over
mo(dot)holkar(at)digitalmindgames(dot)com
http://www.digitalmindgames.com


In response to

Responses

pgsql-novice by date

Next:From: Stephen IngramDate: 2002-02-20 21:11:10
Subject: Re: Question about restricting the number of rows returned from a query.
Previous:From: Philip HallstromDate: 2002-02-20 20:50:02
Subject: Re: Question about restricting the number of rows returned from a

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