title: SQL select Distinct with where clause
body: <p>I have i table like this.</p>
  
  <pre><code>PersonID, KvalifikationId
  1         1
  1         2
  1         3
  2         1
  2         3
  </code></pre>
  
  <p>I want to write SQL querye returning all persons, that have not kvalifikation 2.</p>
  
  <p>i Wrote</p>
  
  <pre><code>SELECT DISTINCT PersonID where NOT KvalifikationID = 2
  </code></pre>
  
  <p>But this return both person 1 and person 2.
  How do i make select that only return personId's that not have kval2 ?</p>