Skip to content

Instantly share code, notes, and snippets.

@zvermafia

zvermafia/Get duplicated values in rows of a table

Last active November 11, 2021 19:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zvermafia/4e424a7cb0b1c6b6734bef6c8976beb4 to your computer and use it in GitHub Desktop.
Save zvermafia/4e424a7cb0b1c6b6734bef6c8976beb4 to your computer and use it in GitHub Desktop.
Download ZIP
SQL - snippets
Raw
Get duplicated values in rows of a table
SELECT name, COUNT(name) FROM users GROUP BY name HAVING COUNT(name) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment