查询表A中存在ID重复三次以上的记录

 

select * from (select count(*) as count from date_record group by year) T where T.count>3

8、查询表A中存在ID重复三次以上的记录,完整的查询语句如下：
select * from(select count(ID) as count from table group by ID)T where T.count>3