如何将已出现的数据通过where条件筛选掉

Question

我有一张表如下：

ID Status

101 Pass

102 Fail

103 Fail

102 Pass

104 Fail

我想要筛选出没有过Pass的ID，即103和104。但是我在where条件中添加Status != ‘Pass’ ，结果中仍会出现102。该怎么解决？

Answer 1

你好，

试试这个语句：

SELECT DISTINCT ID FROM YourTable
WHERE Status <> 'Pass'
EXCEPT
SELECT DISTINCT ID FROM YourTable
WHERE Status = 'Pass'

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".