Find duplicates

SELECT emosid, COUNT(username) AS cnt FROM staffuser_copy GROUP BY emosid HAVING cnt >1;