在STUDENT表中按class_type统计数据行数分组情况后,筛选出数据行数为大于10行的组
在STUDENT表中按class_type统计数据行数分组情况后,筛选出数据行数为大于10行的组
SELECT class_type,COUNT(*) FROM STUDENT GROUP BY class_type HAVING COUNT(*)>10
SELECT class_type,COUNT(*) FROM STUDENT GROUP BY class_type WHERE COUNT(*)=10
SELECT class_type,COUNT(*) FROM STUDENT HAVING COUNT(*)>10 GROUP BY class_type
SELECT class_type,COUNT(*) FROM STUDENT WHERE COUNT(*) >10 GROUP BY class_type