Select duplicated records in a table and match with another table November 06, 2015 SELECT ID,NAME,COUNT(*) FROM TABLE_NAME WHERE ID IN ( SELECT ID_2 FROM TABLE_NAME) GROUP BY ID,NAME HAVING COUNT(*) >1; Share Get link Facebook X Pinterest Email Other Apps Share Get link Facebook X Pinterest Email Other Apps Comments
Comments
Post a Comment