Database programs such as SQL allow organizations to keep track of and maintain large volumes of information. Any database with multiple users authorized to make additions can contain duplicate entries and redundant information. The excess information could cause potential waste in the form of duplicate mailings or increased processing time. Running a report script to locate duplicate members allows you to manage and clean your membership databases.
Instructions
-
-
1
Run your preferred SQL managing application, such as Oracle SQL Developer.
-
2
Open the "Run SQL Report" window. Enter "SELECT name, COUNT(name) as NumOccurences FROM members GROUP BY name HAVING ( COUNT(name) > 1 )" without the quotation marks.
-
-
3
Click "Run Report" to view the list of member names that appear more than once in your membership database.