title: SQL Query to find which group does not have a given value
body: <p>I am using T-SQL. </p>
  
  <p>Say if I have the following</p>
  
  <pre><code>Value     Nbr
  -----     ---
  one       6
  one       7
  one       8
  two       6
  two       7
  three     5
  three     3
  three     2
  </code></pre>
  
  <p>In the above table, I need to find which group does not have 6 in it.
  In this case, it is three as it does not have 6 in it.</p>
  
  <p>What would be the best approach to do this?</p>
  
  <p>I tried:</p>
  
  <pre><code>      select Value from tbl1 
        where nbr &lt;&gt; 6
        group by Value 
  </code></pre>
  
  <p>but did not get the intended result.</p>