摘要：--查询出所有有重复的数据 select s.year,s.oneday,count(*) from SYS_CALENDAR s group by s.year,s.oneday having count(*)>1 order by s.year,s.oneday; --删除重复数据 delete 阅读全文