Difference between revisions of "Find duplicates"
From MyWiki
(Created page with "<source lang="sql"> select emosid, count(username) as cnt from staffuser_copy group by emosid having cnt >1; </source>") |
(No difference)
|
Revision as of 17:45, 21 October 2014
SELECT emosid, COUNT(username) AS cnt FROM staffuser_copy GROUP BY emosid HAVING cnt >1;
