which is not functionally dependent on columns in GROUP BY c 原创

# [Err] 1055 - Expression which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

复制SQLSELECT 
* 
FROM 
lx_dict_detail
WHERE d_id='123'
GROUP BY creator
1
2
3
4
5
6

给所有字段加any_value函数  

复制JavaSELECT 
any_value(id),
any_value(name),
any_value(creator)
FROM 
lx_dict_detail
WHERE d_id='123'
GROUP BY creator
1
2
3
4
5
6
7
8

其他方法可参考

https://blog.csdn.net/qq_33621326/article/details/95950264