-- SELECT sex,COUNT(id) FROM studentinfo GROUP BY sex
-- SELECT classid,COUNT(id) FROM studentinfo GROUP BY classid
SELECT classid,COUNT(*) AS 人数 FROM studentinfo GROUP BY classid
模糊查询与分组查询采用group by 来分组查询源代码– SELECT sex,COUNT(id) FROM studentinfo GROUP BY sex– SELECT classid,COUNT(id) FROM studentinfo GROUP BY classidSELECT classid,COUNT(*) AS 人数 FROM studentinfo GR...