Skip to content

Instantly share code, notes, and snippets.

@ken-muturi

ken-muturi/duplicates_count.sql

Created November 17, 2013 05:26
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ken-muturi/7509667 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ken-muturi/7509667 to your computer and use it in GitHub Desktop.
Download ZIP
Duplicate Count
Raw
duplicates_count.sql
SELECT trim(user_name), COUNT(user_name) AS dup_count
FROM dataentry_users
GROUP BY trim(user_name)
HAVING (COUNT(trim(user_name)) > 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment