mysql5.5升级5.7后group by处理问题

Question

mysql5.5升级5.7后如何获取相同的结果group by原始表5.5查询如下：SELECT ename,salary,birthday,sex FROM employee GROUP BY sexmysql5.7版本要求 group by如下才能保证正常运行SELECT ename,salary,birthday,sex FROM employee GROUP BY sex,ename,salary,birthday如何在不改变mysql数据库的配置模式情况下得到与5.5版本相同的结果？？？