[Bug0038]mysql使用group by查询报错SELECT list is not in GROUP BY clause and contains nonaggregated column...解决方案

1、问题

SQL 错误 [1055] [42000]: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'station.sw.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

2、场景

3、原因

4、解决方案

参考

参考