这个问题是数据库设置了only_full_group_by
模式:
错误的sql:
SELECT content,teacherId FROM tb_test GROUP BY teacherId;
正确的sql:(因为一个teacherId 会对应多个content的情况所以content要加上any_value())
SELECT any_value(content) AS content,teacherId FROM tb_test GROUP BY teacherId;
这个问题是数据库设置了only_full_group_by
模式:
错误的sql:
SELECT content,teacherId FROM tb_test GROUP BY teacherId;
正确的sql:(因为一个teacherId 会对应多个content的情况所以content要加上any_value())
SELECT any_value(content) AS content,teacherId FROM tb_test GROUP BY teacherId;