I have this table in sql server with the name address looking like this:
The table consists of data from different databases and I know there are duplicate addresses in there.
I would like to compare city, zip and lastname, so that those that have more than one instance in the table are left out (they are only shown one time).
How can I achieve this?
Thanks for help!