SELECT column,COUNT(*) c FROM table GROUP BY column HAVING COUNT(*) > 1
results show the column value and the number of duplicates for that value
2798 users tagging and storing useful source code snippets
Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)
SELECT column,COUNT(*) c FROM table GROUP BY column HAVING COUNT(*) > 1
You need to create an account or log in to post comments to this site.