Re: Question about restricting the number of rows returned from a

Select f1 from table1
LIMIT 50;

Patrick Hatcher
Macys.Com
Legacy Integration Developer
415-932-0610 office

Stephen Ingram
<ingram(at)samsix(dot)com> To: pgsql-novice(at)postgresql(dot)org
Sent by: cc:
pgsql-novice-owner(at)post Subject: [NOVICE] Question about restricting the number of rows
gresql.org returned from a query.


02/20/2002 12:03 PM
Please respond to
ingram

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly