ggendre/gist:1053964

Created June 29, 2011 14:40

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

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

Download ZIP

SQL find duplicates 1/2

Raw

gistfile1.sql

	SELECT user.*
	FROM user,
	(SELECT id_user
	FROM user
	GROUP BY id_user
	HAVING count( * ) >1
	) doublons
	WHERE user.id_user = doublons.id_user;

Author

ggendre commented Jun 29, 2011

see http://ggendre.posterous.com/doublons-mais-pas-trop-vite

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