摘要： 1、查找表中多余的重复记录 select * from 表 a where (a.Id,a.seq) in(select Id,seq from 表 group by Id,seq having count(*) > 1) --a.Id+a.seq唯一 select * from bi_networ 阅读全文