asilbalaban/tekrar.sql

Created December 24, 2013 08:54

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/asilbalaban/8110561.js"></script>
Save asilbalaban/8110561 to your computer and use it in GitHub Desktop.

Download ZIP

SQL tekrar eden sonuçları bulma

Raw

	SELECT
	mail, sehir, COUNT(*)
	FROM
	mails
	GROUP BY
	mail
	HAVING
	COUNT(*) > 1
	ORDER BY
	COUNT(*) DESC

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