title: Select Rows which does not satisfiy Predicate in SQL Server
body: <p>I have a table with 2 columns GroupID and Value. Column GroupID have two groups 1 and 2 and its respective values. I have to select GroupID which 
  do not have Value 4 </p>
  
  <pre><code>GroupID Value
  1            4
  1            5
  1            6
  1            7
  1            8
  2            5
  2            7
  2            8
  2            9
  2            3
  
  OutPut:
  
  GroupID   Value
  2         5
  2         7
  2         8
  2         9
  2         3
  </code></pre>