title: how to retrieve a list including and excluding a particular key?
body: <p>i have a table like this where i need to filter on key and retrieve list of keys.</p>
  
  <pre><code>id key
  1   1
  1   2
  1   3
  1   4
  2   1
  2   3
  3   1
  3   4
  4   1
  4   4
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>id key
  2   1
  2   3
  3   1
  3   4
  </code></pre>
  
  <p>Here i want to get a list of id i.e (2,3) in which key 1 is present and key 2 is missing.</p>