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

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to find out top 3 records in each location
Date: 2006-11-20 17:48:22
Message-ID: 20061120174822.GB29317@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
--George Orwell

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-20 17:49:19 Re: How to find out top 3 records in each location
Previous Message wen tseng 2006-11-20 17:09:00 How to find out top 3 records in each location