SQL Query – Duplicate Contacts

The following SQL Query will display a list of contacts with the same contact name.  You can then browse through the list to see if they are any potential duplicates.

Select accountno, contact, company, phone1, city, state
From contact1
Where contact in
(Select contact from contact1 group by contact having count(contact)>1)
and contact is not null and contact <> ”
Order by contact