Re: Lowest 2 items per

> -----Original Message-----
> From: David Johnston [mailto:polobo(at)yahoo(dot)com]
> Sent: Friday, June 01, 2012 11:13 AM
> To: Relyea, Mike
> Cc: <pgsql-sql(at)postgresql(dot)org>
> Subject: Re: [SQL] Lowest 2 items per
>
>
> I would recommend using the "RANK" window function with an appropriate
> partition clause in a sub-query then in the outer query you simply
WHERE
> rank <= 2
>
> You will need to decide how to deal with ties.
>
> David J.

David,

I've never used window functions before and rank looks like it'd do the
job quite nicely. Unfortunately I'm using 8.3 - which I should have
mentioned in my original request but didn't. Window functions weren't
introduced until 8.4 from what I can tell.

Mike