Posted By

atma on 02/20/10


Tagged

mysql


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

dantreacy
virendrakryadav
jeremydouglass


Find values that occur exactly once in table


 / Published in: MySQL
 

  1. SELECT email
  2. FROM users
  3. GROUP BY email
  4. HAVING ( COUNT(email) = 1 )

Report this snippet  

You need to login to post a comment.