找到多列重复筛选

select Eoptype,Factory_cname,COUNT(*) FROM KOP_Config_CIP
GROUP BY Eoptype,Factory_cname HAVING COUNT(*)>1