Skip to content

Instantly share code, notes, and snippets.

@mlshvdv

mlshvdv/mysql-get-dublicated.sql

Created March 24, 2014 09:24
Show Gist options
  • Save mlshvdv/9737023 to your computer and use it in GitHub Desktop.
Save mlshvdv/9737023 to your computer and use it in GitHub Desktop.
Download ZIP
Получить повторяющиеся записи в MySQL
Raw
mysql-get-dublicated.sql
SELECT `user_login`, count(*) as total FROM users GROUP BY `user_login` HAVING total > 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment