Facebook Interview Question
Software Engineer / Developersselect email from email_table
where email NOT IN
(select email from email_table where count(email) = 1)
This will always return 0 row, but the following might work
select email from email_table
MINUS
select distinct email from email_table
select email, count(email)
- gallant March 01, 2009from table
group by email
having count(email) > 1