MySql--查询某字段相同数据的条数据

1：select sampling,count(*) from aa  group by sampling having count(*)>1;