Postgres Pro
Downloads
Home   >   mailing lists

Question about restricting the number of rows returned from a query. - Mailing list pgsql-novice

From Stephen Ingram
Subject Question about restricting the number of rows returned from a query.
Date
Msg-id 20020220200915.RWGL19363.femail5.sdc1.sfba.home.com@there
Whole thread Raw
Responses Re: Question about restricting the number of rows returned from a  (Philip Hallstrom <philip@adhesivemedia.com>)
Re: Question about restricting the number of rows  (Mo Holkar <pgsql@digitalmindgames.com>)
Re: Question about restricting the number of rows returned  (Tuna Chatterjee <tchatter@alert.infoplease.com>)
List pgsql-novice
Tree view 

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?

cheers

steve

pgsql-novice by date:

Previous
From: Pam Wampler
Date:
Subject: Re: inserting a timestamp show wrong timezone
Next
From: Philip Hallstrom
Date:
Subject: Re: Question about restricting the number of rows returned from a