Find duplicates in value using SQL command

 SELECT

    username,

    email,

    COUNT(*)

FROM

    users

GROUP BY

    username,

    email

HAVING

    COUNT(*) > 1

or,

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;