Skip to content

Instantly share code, notes, and snippets.

@viniciusmelocodes

viniciusmelocodes/select_apenas_registros_repetidos.sql

Created February 1, 2022 17:16
Show Gist options
  • Save viniciusmelocodes/2e4d8ac47c6f0c0ff33cd32bac7fc9a1 to your computer and use it in GitHub Desktop.
Save viniciusmelocodes/2e4d8ac47c6f0c0ff33cd32bac7fc9a1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select_apenas_registros_repetidos.sql
SELECT
CAD.CADASTRO_ID,
COUNT(*)
FROM
CADASTROS CAD
GROUP BY
CAD.CADASTRO_ID
HAVING
COUNT(*) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment