mysql - SQL Update query with group by clause - Stack ...

2011年8月1日 - update table1 set name='HIGH' having age = max(age) group by type; ... update ta a1 inner join (select type ty,max(age) mage from ta) a2 on ...

stackoverflow.com