Some SQL to demonstrate an insert select causing a primary key violation and how to identify the duplicate rows. — this insert is a clash with t1 table — use exists and subquery to source to see what rows match in both tables COL1 COL2 COL3 COL4 —————————— A 1 A 1 — this is … Continue reading How to Find Duplicate rows from 2 tables