How to find Duplicate Records In table?

Saddam Gour

652

select COUNT(*) as DuplicateValues,Name from tablea group by Name having count(*)>1

select COUNT(NAME) > 1