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 по дате отправления:

Предыдущее
От: "wen tseng"
Дата:
Сообщение: How to find out top 3 records in each location
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: How to find out top 3 records in each location