How to find Duplicate Records In table?
Saddam Gour
select COUNT(*) as DuplicateValues,Name from tablea group by Name having count(*)>1
select COUNT(NAME) > 1