mysql怎么统计某个字段具体重复的次数

2025-02-27 19:01:23
推荐回答(1个)
回答1:

SELECT type, count(1) AS counts
FROM material
GROUP BY type。这是统计material表中type的重复次数