To check whether a field contain duplicate values in the database via sql query

Using below queries you can get the duplicate name field details of names table

SELECT id, name, COUNT( name) 
FROM names
GROUP BY name
HAVING (
COUNT( name) >1
)