Re: GROUP BY & column not in select list

Lew wrote:
> Lew wrote:
>>  SELECT name, MAX(userid) AS userid, MAX(age)
>>   FROM users GROUP BY name
>>    ORDER BY name;
> 
> Crap.  This won't work.

MAX() works independently on each column, so this "solution" will not 
guarantee correct correlation of userid to age.

"Correlation", did I say?  This calls for a correlated subquery:

  SELECT name, userid, age
   FROM users u WHERE age IN
    (SELECT MAX(age) FROM users x WHERE x.name = u.name)
  ;

-- 
Lew