We can use below query:
Select * from TBL1 a INNER JOIN (Select col1, count(1) from TBL1 having count(1)>1 group by 1)REF ON (a.col1=ref.col1)
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!