title: Filtering on ANY
body: <p>I have the following table:</p>
  
  <pre><code>studentID subjectID PASS
  101        1         T
  102        1         F
  101        2         F
  101        3         T
  102        2         F  
  </code></pre>
  
  <p>I should raise an alert <code>if a student has not passed in ALL of the subjects he had attempted.</code>  </p>
  
  <p>So,in the above case - <code>the query should return only 102.</code> </p>
  
  <p><code>Note - it should also not return 103,who has not attempted any of the subjects(assuming we are joining this with the student table).</code></p>