Top N Records Per Group

From: valerie(at)webtribe(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Top N Records Per Group
Date: 2002-07-30 07:11:00
Message-ID: 200207300711.IAA13011@leopard.webtribe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a "top" function in postgres? I've had a look and
don't see one.

As an example: How would I extract the top 5 salesmen PER
region using Postgres?

TIA

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2002-07-30 10:58:18 Re: phpPgAdmin problem
Previous Message frank_lupo 2002-07-30 06:34:52 Re: Execute vacuum postgresql crash