Skip to content

Instantly share code, notes, and snippets.

@kissmygritts

kissmygritts/duplicates.sql

Created May 7, 2015 22:05
Show Gist options
  • Save kissmygritts/fca990cf07413906e4db to your computer and use it in GitHub Desktop.
Save kissmygritts/fca990cf07413906e4db to your computer and use it in GitHub Desktop.
Download ZIP
Example of finding duplicates with SQL
Raw
duplicates.sql
SELECT data_Capture.WHno, Count(data_Capture.WHno) AS CountWHno
FROM data_Capture
GROUP BY data_Capture.WHno
HAVING Count(data_Capture.WHno)>1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment