medium10 pts · first answer countssqltest-data-management

Finding duplicate records with SQL

Registration should block duplicate emails. Which query finds emails that appear more than once in the users table?

A.SELECT email FROM users WHERE COUNT(*) > 1;B.SELECT email, COUNT(*) FROM users GROUP BY email HAVING COUNT(*) > 1;C.SELECT DISTINCT email FROM users;D.SELECT email FROM users ORDER BY email;

← Three Amigos session Take the medium mock interview →