DevJulianSalas/Querys.sql

Last active February 2, 2018 15:34

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

Download ZIP

Queys to SQL engine

Raw

	-- To know if x column have elements repeated

	SELECT `name_column`, COUNT(1) as CNT
	FROM `name_column`
	GROUP BY `n`
	HAVING COUNT(1) >1;

	---

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