SELECT name, class_id, COUNT(*) num FROM students GROUP BY class_id;
把only_full_group_by加到sql_mode里
Sign in to make a reply
阳光帅气的Jack
SELECT name, class_id, COUNT(*) num FROM students GROUP BY class_id;