Skip to content

Instantly share code, notes, and snippets.

@monbang

monbang/Duplicates in table

Created May 4, 2020 03:34
Show Gist options
  • Save monbang/b8fdd2924caf0a70a71c9041c8f65247 to your computer and use it in GitHub Desktop.
Save monbang/b8fdd2924caf0a70a71c9041c8f65247 to your computer and use it in GitHub Desktop.
Download ZIP
Duplicates in table
Raw
Duplicates in table
// https://stackoverflow.com/a/2594855
SELECT name,
reg_no,
CLASS,
SECTION,
count(*)
FROM cps_student
GROUP BY name,
reg_no
HAVING count(*) > 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment