两条语句结果不一样:
SELECT * FROM td_neo_crm_course_change_pay WHERE state_deleted=0 GROUP BY course_change_id,pay_type HAVING(COUNT(id)) > 1;
SELECT * FROM td_neo_crm_course_change_pay GROUP BY course_change_id,pay_type HAVING(COUNT(id)) > 1;
mysql8,具体什么原因,请留言!