Find values that occur exactly once in table - MySQL Snipplr Social Repository

Revision: 24093

at February 20, 2010 21:06 by atma

Initial Code

SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )

Initial URL

Initial Description

Initial Title

Find values that occur exactly once in table

Initial Tags

mysql

Initial Language

MySQL