Skip to content

Instantly share code, notes, and snippets.

@tfgrahame

tfgrahame/duplicate-uids.sql

Created June 22, 2018 09:52
Show Gist options
  • Save tfgrahame/6b19c979f453c8db7bac800be72e1582 to your computer and use it in GitHub Desktop.
Save tfgrahame/6b19c979f453c8db7bac800be72e1582 to your computer and use it in GitHub Desktop.
Download ZIP
duplicate-uids.sql
Raw
duplicate-uids.sql
SELECT
id.value, COUNT(id.entity_pid)
FROM
identifier id
WHERE
id.type = 'uid'
GROUP BY id.value
HAVING COUNT(id.entity_pid) > 1
ORDER BY id.created DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment