Question about restricting the number of rows returned from a query.

From: Stephen Ingram <ingram(at)samsix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Question about restricting the number of rows returned from a query.
Date: 2002-02-20 20:03:13
Message-ID: 20020220200915.RWGL19363.femail5.sdc1.sfba.home.com@there
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Patrick Hatcher 2002-02-20 20:46:55 Re: Question about restricting the number of rows returned from a
Previous Message Cyril Samovskiy 2002-02-20 18:23:27 foreign key is from different tables - what to do?