sql - 带 WHERE 的 DISTINCT 子句

Question

如何在 WHERE 中使用 DISTINCT 子句？例如:

SELECT * FROM table WHERE DISTINCT email; -- email is a column name

我想从具有不同电子邮件地址的表中选择所有列。

Answer 1

如果您的意思是电子邮件唯一的所有列:

SELECT * FROM table WHERE email in
     (SELECT email FROM table GROUP BY email HAVING COUNT(email)=1);