On Tue, Feb 08, 2005 at 10:36:17AM +1000, q2005 wrote:
>
> Is there any better alternative to get the first record from each group?
PostgreSQL has a non-standard SELECT DISTINCT ON query for just
this purpose.
http://www.postgresql.org/docs/8.0/static/queries-select-lists.html#QUERIES-DISTINCT
http://www.postgresql.org/docs/8.0/static/sql-select.html#SQL-DISTINCT
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/