Skip to content

Instantly share code, notes, and snippets.

@Jhowam

Jhowam/Finding Duplicates with SQL

Created June 7, 2018 06:30
Show Gist options
  • Save Jhowam/5dfb0bb376fdc81366d85a16eafe047c to your computer and use it in GitHub Desktop.
Save Jhowam/5dfb0bb376fdc81366d85a16eafe047c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Finding Duplicates with SQL
SELECT clientid,
COUNT(clientid)
FROM client
GROUP BY clientid
HAVING ( COUNT(clientid) > 1 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment