mysql 同一字段查询重复数据

select h_date,count(*) as count from sf_holiday group by h_date having count>1;