title: select ids with particular entries on another column
body: <p>Apologies if this exists in another question but I'm unable to locate it. Say I have a table</p>
  <pre><code>ID   Type
  1     A
  1     A
  4     A
  1     A
  1     A
  2     A
  2     B
  3     A
  3     A
  3     B
  4     A
  1     A
  4     A
  </code></pre>
  <p>I want to select the ids that only have entry 'A' in the Type column for all their row entries. Expected output should be:</p>
  <pre><code>ID
  1
  4
  </code></pre>
  <p>I attempted to do this</p>
  <pre><code>select id 
  from table 
  order by id 
  having Type = 'A'
  </code></pre>
  <p>but not getting expected result.</p>