How to find duplicate customer where no unique column exists ?
Hi,
Following is a sample dataset. The all 4 account is from same customer. We have many customers who have multiple account like this, but we don't have any unique ID/Column to identify that all the four account is from same customer. Would you please help with some SQL query where we can identify these types of accounts. We will merge them later.
CUSTOMERNO | FULLNAME | NID | BIRTHCRETIFICATENO | TIN | PASSPORTNO | FATHERNAME | MOTHERNAME | DOB |
|---|---|---|---|---|---|---|---|---|
100001379645 | Dwayne Douglas Johnson | 215765215 |
|
|
| Mr. Rocky Johnson | NULL | 1/1/1980 |
100001379756 | Dwayne Jahnsan |
| 2365987412563 |
|
| NULL | Dawn Marie Johnson | 1/1/1980 |
100001370755 | Mr. Dwoyne |
|
| 5987412569 |
| Mr. Racky | NULL | NULL |
100001480645 | Mr. Dauglas Jahnsan |
|
|
| XX126589 | Mr. Rocky Jahnsan | NULL | 1/1/1980 |
Thanks a lot.
Tagged:
0