Mysql Group By时查询多个字段报错问题解决

1、

SELECT pk_class ,COUNT(tc.fk_course) AS num FROM t_course_class AS tc
    WHERE deleted=0 AND 
     GROUP BY tc.fk_course 

报错:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY tc.fk_course' at line 3

 

报错原因： GROUP By需要和聚合函数配合使用，GROUP By肯定是取多条数据中的一条，所以把pk_class改成Max(pk_class)或者Min(pk_class)就对了，一下是正确Sql:

SELECT Max(pk_class) AS class_id ,COUNT(tc.fk_course) AS num FROM t_course_class AS tc
    WHERE deleted=0 AND 
     GROUP BY tc.fk_course