mysql中查询某个字段重复的数据

SELECT corp_name,count(*) as sums FROM corp_tax WHERE corp_year = 2018 AND corp_month = 8 group by corp_name HAVING sums >1