title: How to not display an item in select query?
body: <p>I feel a little stupid asking this because I feel like this is very easy, but for some reason I'm not able to update a query to not select a specific item based on two criteria.</p>
  
  <p>Let's say I have data like this:</p>
  
  <pre><code> ID       Name       Variant     Count1
   110      Bob        Type1       0
   110      Bob        Type2       1
   120      John       Type1       1
  </code></pre>
  
  <p>So as you can see we have two BOB rows with same ID but different variant (type1 and type2). I want to be able to only see one of the Bob's. </p>
  
  <p>Desired result:</p>
  
  <pre><code> 110      Bob        Type2
   120      John       Type1
  </code></pre>
  
  <p>So what I've been doing is something like</p>
  
  <pre><code> Select ID, Name, Variant, sum(count1) from tbl1
   where (id not in (110) and Variant &lt;&gt; 'type1')
   Group by Id,name,variant
  </code></pre>
  
  <p>Please don't use COUNT as a criteria, because in my example it just so happens that Count=0 for the row that I don't want to see. It can vary.</p>
  
  <p>I have many rows where I can have multiple instances of the same id with a variety of different VARIANTS. I'm looking to exclude certain instances of ID based on Variant value</p>
  
  <p>UPDATE:</p>
  
  <p>It has nothing to do with latest variant, it has to do with a <em>specific</em> variant. So I'm just looking to basically be able to use a clause where i used the ID and VARIANT, in order to remove that particular row. </p>