Re: Some insight on the proper SQL would be appreciated

In article <4C0F4BA8(dot)3040805(at)gmail(dot)com>,
Ognjen Blagojevic <ognjen(dot)d(dot)blagojevic(at)gmail(dot)com> writes:

> Plenty of solutions here:
> http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/

This doesn't mention the incredibly powerful windowing functions of
PostgreSQL >= 8.4.0:

SELECT username, firstname, lastname, signedup
FROM (
SELECT username, firstname, lastname, signedup,
row_number() OVER (PARTITION BY username ORDER BY signedup)
FROM mytbl
) dummy
WHERE row_number <= 5