模糊查询与分组查询 采用group by 来分组查询 SELECT * FROM category WHERE catename LIKE'%川%' -- 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