Find duplicate values in SQL

SELECT user, COUNT(user) AS cant
FROM adm_users
GROUP BY user
HAVING COUNT(user)>1