Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I inherited a project from someone who wrote a long convoluted program to look for duplicates in a table. I'm wondering if it could be done easier using SQL. Here's an example of the problem we have frequently:
Record 1
------------------------
JOHN
L
SMITH
1234 ANYWHERE LANE
HERESVILLE
PA
16555
------------------------
Record 2
------------------------
JOHN
SMITH
1234 ANYWHERE LN
HERESVILLE
PA
16555-2345
------------------------
Records 1 and 2 are the same person, but a SELECT DISTINCT does not eliminate one of them because the middle initial, address line, and zip code are not identical. My question is this, is there a way with SQL to identify these two records, which are in the same file, as "possible" duplicates which I could then display to a user for them to decide what to do with them?
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement