title: How to write sql query to select rows having which does not contain any of the values in array
body: <pre><code>id  code
  1   a
  1   b
  1   c
  1   d
  1   e
  2   a
  2   b
  2   d
  2   e
  3   a
  3   d
  3   e
  </code></pre>
  
  <p>this is my table here (2,c) and (3,b) is missing out , so how to get only the missing out Id's keeping the code values (a,b,c,d,e,f) as static values even if any of the combination of ID and Code is missing.
  Eg:(1,a),(1,b),(1,c),(1,d),(1,e) are mandatory i need the ID as 1 even if (1,c) is missing out</p>