mamoo/gist:33650f7ade2dd588c038

Created October 7, 2014 06:39

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mamoo/33650f7ade2dd588c038.js"></script>
Save mamoo/33650f7ade2dd588c038 to your computer and use it in GitHub Desktop.

Download ZIP

Find duplicate column value in DB

Raw

gistfile1.sql

SELECT col_1, COUNT(*) FROM table GROUP BY col_1 HAVING COUNT(*) > 1;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment