Remove Duplicate rows in Sql
Posted on 2002-06-26
I need a little help with a sql script
I have a huge table of addresses with numerous duplicates, I need a script that will look at the table and if it see's more than one row with identical data it will delete any of the extra rows and only leave one row of that data.
My table name is "Person_Address", I want the script to look at the "master_name_key","house_number" and "Street" field. If there is more than one row with the identical three peices of data (or identical nulls) in all three fields then delete all the extras leaving me just one.