Skip to content

Instantly share code, notes, and snippets.

@kencenerelli

kencenerelli/gist:5413677

Created April 18, 2013 15:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kencenerelli/5413677 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kencenerelli/5413677 to your computer and use it in GitHub Desktop.
Download ZIP
Query duplicate records in a SQL Server table
Raw
gistfile1.sql
SELECT Column1, Column2, COUNT(*) AS Amount
FROM TableName
GROUP BY Column1, Column2
HAVING (COUNT(*) > 1)
ORDER BY Column1, Column2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment