Re: subquery bug ?

[Benoit St-Jean]

You need something like this (btw your results were wrong):

SELECT sb.id, sb.some_type, sb.some_name
FROM subquerybug sb
INNER JOIN
(
SELECT id, MAX(some_type) AS biggest_type
FROM subquerybug
GROUP BY id
) t1
ON (t1.id=sb.id AND sb.some_type=t1.biggest_type);

Also, try not to use reserved/special words (e.g. TYPE) for column names : it will save you from lots of headaches!