Re: Question about restricting the number of rows returned - Mailing list pgsql-novice

hi steve,

i believe the syntax would be:
"SELECT columns
FROM myTable
WHERE myConditions = conditions
LIMIT 50";

additionally, if you'd want to select rows 51 to 100 i think the last
line would read:
OFFSET 50 LIMIT 50

take care,
tuna chatterjee


On Wed, 2002-02-20 at 15:03, Stephen Ingram 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?
>
> cheers
>
> steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly