2条sql查询的结果不一样,是什么原因导致?

2023-09-15 09:00:08 浏览数 (3)

两条语句结果不一样: 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,具体什么原因,请留言!

1 人点赞