MYsql 统计字段相同出现次数

SELECT name,mun,COUNT(1) cnt FROM table_baidu

GROUP BY name,mun HAVING name IN('Y100','X100')

SELECT type, count(1) AS counts

FROM material

GROUP BY type。这是统计material表中type的重复次数

---