统计某个字段的种类的个数 

SELECT
 type, 
 count(1) AS counts 
FROM
 material 
GROUP BY
 type

 

posted @ 2017-06-27 22:13  安筱雨  阅读(441)  评论(0)  编辑  收藏  举报