mysql GROUP BY 取分组中最小（OR 最大）的一条记录

代码

select d.* FROM
sem_database_export as d
LEFT JOIN 
(
SELECT a.id,a.keyname,a.shebei,a.adverts_lei,a.adverts_pinpai,
MAX(a