求教个Sql写法

[JeremyChenX]

数据源：

想统计按照name分组数量大于1后的，分组之和

[nantong-xiaosong]

SELECT name AS '名称',count(name) AS '数量' FROM tableName GROUP BY name HAVING count(name) > 1;

[廉月程]

SELECT count(cnt ) from( SELECT name,count(name) as cnt FROM tableName GROUP BY name HAVING count(name) > 1);