Skip to content

Instantly share code, notes, and snippets.

@DevJulianSalas

DevJulianSalas/Querys.sql

Last active February 2, 2018 15:34
Show Gist options
  • Save DevJulianSalas/0679d63022a1673d2c7fcc90cf25991b to your computer and use it in GitHub Desktop.
Save DevJulianSalas/0679d63022a1673d2c7fcc90cf25991b to your computer and use it in GitHub Desktop.
Download ZIP
Queys to SQL engine
Raw
Querys.sql
-- 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