Pls help - Limiting query results by percentage of results

Поиск
Список
Период
Сортировка
От Brian G. Huber
Тема Pls help - Limiting query results by percentage of results
Дата
Msg-id 000801c36755$663b4fb0$6400a8c0@bghmobile
обсуждение исходный текст
Ответы Re: Pls help - Limiting query results by percentage of results  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
Дерево обсуждения
Hello all -
 
I am trying to limit the results of a query using the LIMIT clause - but instead of an absolute number I would like to limit by a percentage of rows returned. 
 
It seems the LIMIT clause only supports absolute numbers.  Any ideas greatly appreciated.
 
TIA,
BGH
 
PS - The analogous syntax in Access is "SELECT TOP n PERCENT"  which returns the top n percent of rows ordered by ORDER BY.

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

Предыдущее
От: "dan"
Дата:
Сообщение: Help with pg_restore
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Pls help - Limiting query results by percentage of results