本文共 382 字，大约阅读时间需要 1 分钟。

1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'btc.a.applicant_unit' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

执行下如下语句，然后重新运行语句，就可以正常查询了。

set sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

转载地址：https://blog.csdn.net/W_317/article/details/116723943 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！