Skip to content

Instantly share code, notes, and snippets.

@artem-a

artem-a/query.sql

Last active March 30, 2018 08:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save artem-a/8c0869bade09014d21c4e4de9a084ba4 to your computer and use it in GitHub Desktop.
Save artem-a/8c0869bade09014d21c4e4de9a084ba4 to your computer and use it in GitHub Desktop.
Download ZIP
Find duplicate values with SQL
Raw
query.sql
select * from tb as t1
where (select count(1) from tb as t2 where t1.column ilike t2.column) > 1
order by column;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment