SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.t.address' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

关于查询列不在分组字段内触发错误

之前我一直使用其他写法处理没啥问题但是看到官方有推荐处理方法

https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html

使用ANY_VALUE()方法处理提示的列即可