I have a large table with the following data on users.
social security number
name
address
I want to find all possible duplicates in the table where the ssn is equal but the name is not
My attempt is:
SELECT * FROM Table t1
WHERE (SELECT count(*) from Table t2 where t1.name <> t2.name) > 1
See Question&Answers more detail:os