Re: Question about restricting the number of rows returned

Поиск
Список
Период
Сортировка
От Tuna Chatterjee
Тема Re: Question about restricting the number of rows returned
Дата
Msg-id 1014240003.14226.27.camel@steamer.infoplease.com
обсуждение исходный текст
Ответ на Question about restricting the number of rows returned from a query.  (Stephen Ingram <ingram@samsix.com>)
Список 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



В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephen Ingram
Дата:
Сообщение: Re: Question about restricting the number of rows
Следующее
От: Stephen Ingram
Дата:
Сообщение: Re: Question about restricting the number of rows returned from a query.