Re: Obtaining a limited number of records from a long query

Поиск
Список
Период
Сортировка
От Luiz Eduardo Cantanhede Neri
Тема Re: Obtaining a limited number of records from a long query
Дата
Msg-id 252e1f290905250642w66c6b962k248624b5327be043@mail.gmail.com
обсуждение исходный текст
Ответ на Obtaining a limited number of records from a long query  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
Список pgsql-novice
Дерево обсуждения
Visit http://www.sqlzoo.net/howto/source/z.dir/tip915069/postgres and u'll get ur awnser and others like from 11th and on.

For now you may try SELECT * FROM cia LIMIT 10

On Mon, May 25, 2009 at 10:32 AM, Oliveiros Cristina <oliveiros.cristina@marktest.pt> wrote:
Dear List,
 
Is there any way to force a query to return just a few records?
 
For ex, returning just the first ten rows from a long ORDER BY query ?
 
And then, eventually, obtaining the remaining records at a later time, or in background?
 
Thanks in advance for your help,
 
Best,
Oliveiros

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

Предыдущее
От: "Oliveiros Cristina"
Дата:
Сообщение: Obtaining a limited number of records from a long query
Следующее
От: Daniel Staal
Дата:
Сообщение: Re: Obtaining a limited number of records from a long query