查询是否多于两条重复数据
select * from Tablea a where exists (select count(*) from Tableb b where a.col1= b.col1 and a.col2=b.col2 and a.col3= b.col3 having count(*)>2)
查询是否多于两条重复数据
select * from Tablea a where exists (select count(*) from Tableb b where a.col1= b.col1 and a.col2=b.col2 and a.col3= b.col3 having count(*)>2)