Skip to content

Instantly share code, notes, and snippets.

@primogf

primogf/registros_duplicados.sql

Created April 7, 2017 18:34
Show Gist options
  • Save primogf/c018a42bcda41fd7af79f4d427b0d32a to your computer and use it in GitHub Desktop.
Save primogf/c018a42bcda41fd7af79f4d427b0d32a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
registros_duplicados.sql
SELECT
DCB,
Count(*)
FROM
Document d
INNER JOIN DocumentOrigin o ON o.id_documento = d.id_documento
GROUP BY DCB
HAVING Count(*) > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment