My answer are select * from T T1 where exists(select A from T where A=T1.A group by A having count(1)>1); or select * from T T1 where exists(select A from T group by A having count(1)>1 and A=T1.A);