group by 语句报错:
Error Code: 1055. Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘×××’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
提示sql_mode=only_full_group_by 不强制推荐关闭sql_mode
**检查你的语法**
,group by 基本语法是
select A,sum(),min() from t group by A
select A,B,sum() from t group by A,B
真要获得B字段,自关联子查询
select tt.A,t.B from (select A,sum(),min() from t group by A) tt, t where t.A=tt.A