SQL Server : do not Select all if true

Question

I have these columns

Id  Status
----------
 1  pass
 1  fail
 2  pass
 3  pass

How do I select all that only have a status of pass but if the Id has at least one fail it will not be selected as well.

Answer 1

If same id can have multiple passes

SELECT id
from table 
WHERE status = 'pass' 
and id NOT IN (SELECT id FROM table WHERE status = 'fail')