Skip to content

Instantly share code, notes, and snippets.

@jazz7381
Created December 24, 2021 07:10
Show Gist options
  • Save jazz7381/e35af430f0685ca15d73d3b389ce2a84 to your computer and use it in GitHub Desktop.
Save jazz7381/e35af430f0685ca15d73d3b389ce2a84 to your computer and use it in GitHub Desktop.
Get data all duplicate except the first data PostgreSQL
SELECT * FROM tablename
WHERE id IN (SELECT id
FROM (SELECT id,
ROW_NUMBER() OVER (partition BY column1, column2 ORDER BY id) AS rnum
FROM tablename) t
WHERE t.rnum > 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment