Fing multiple values in MySQL - MySQL Snipplr Social Repository

Revision: 24092

at February 20, 2010 21:05 by atma

Initial Code

SELECT email, 
 COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Initial URL

Initial Description

Initial Title

Fing multiple values in MySQL

Initial Tags

mysql

Initial Language

MySQL