How to find Duplicate Records In table?

Saddam Mohd

1.5k

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

select COUNT(NAME) > 1