Re: Top N Records Per Group

There is a limit which is similar to SQL2K and there is also an offset
option.

select blah from blah limit 5;

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of
> valerie(at)webtribe(dot)net
> Sent: Tuesday, July 30, 2002 2:11 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Top N Records Per Group
>
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>