To find duplicate entries in single field use below query

 
SELECT fldname FROM tblname GROUP BY fldname HAVING COUNT(fldname)>1