Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql find duplicate records in two tables

SELECT  *   
FROM TableA A  
WHERE NOT EXISTS (SELECT *      
                  FROM TableB B
                  WHERE A.NUM = B.NUM);
Source by learnsql.com #
 
PREVIOUS NEXT
Tagged: #sql #find #duplicate #records #tables
ADD COMMENT
Topic
Name
1+7 =