Monthly Archives: May 2015

Solution:
SELECT t3.`id`, max_table3.max_type
FROM
table3 t3 JOIN
(SELECT id, MAX(`type`) max_type FROM table3 GROUP BY id) max_table3
ON max_table3.max_type = t3.`type` AND max_table3.id = t3.`id`

reference: http://stackoverflow.com/questions/612231/how-can-i-select-rows-with-maxcolumn-value-distinct-by-another-column-in-sql