On 2000-01-25, Chris Bitmead mentioned:
> I think what I really meant was...
>
> SELECT DISTINCT ON firstname firstname, age ORDER BY age.
>
> Which would find the youngest person called "fred", the youngest person
> called "paul", the youngest person called "jim" etc etc. which your
> limit example wouldn't do.
SELECT firstname, min(age) FROM x GROUP BY firstname [ ORDER BY min(age) ]
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
