mysql5.7对分组做了修改

查询未分组字段

SELECT any_value(temp.id),
       any_value(temp.name),
       any_value(temp.sex)
FROM a temp
GROUP BY temp.sex
;

未分组字段排序

虽然查询工具会爆红,但是不影响查询

SELECT any_value(temp.id),
       any_value(temp.name),
       any_value(temp.sex)
FROM a temp
GROUP BY temp.sex
order by any_value(temp.name)
;

查询分组内,根据某个字段最大的一行

SELECT any_value(temp.id),
       any_value(temp.name),
       any_value(temp.sex)
FROM (SELECT distinct id, name, sex FROM a ORDER BY id desc) AS temp
GROUP BY temp.sex
;

distinct必须加上,不然mysql会自动优化sql