Re: How to find out top 3 records in each location

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: How to find out top 3 records in each location
Дата
Msg-id 20061120174822.GB29317@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на How to find out top 3 records in each location  ("wen tseng" <went@hteamericas.com>)
Список pgsql-sql
On Mon, Nov 20, 2006 at 12:09:00PM -0500, wen tseng wrote:
> 
> Since PostgreSQL doesn't support TOP, how can I do to get this result?
> Any solution will be appreciated.

Check out the crosstab stuff in contrib/; I think it does what you
want.

a

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.    --George Orwell


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