This article describes how to identify duplicate records in a SQL table.

Use the Group By / Having combination in a Select statement

Select
ID
From
Table
Group By
ID
Having
Count(ID) > 1