模糊查询与分组查询I

模糊查询与分组查询

采用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