I have a table that has addresses
I need to delete the duplicates. I know there is a duplicate if the 'street' is exactly the same. I need to keep ONE of the rows that are duplicate, if there are no duplicates leave the record as is.
table = addresses
field = street
I tried this but did not work out:
DELETE FROM [Addresses] WHERE [Street] IN (
SELECT id FROM [Addresses] GROUP BY id HAVING ( COUNT([Street]) > 1 )