title: SQL to check for all values in column
body: <p>I have the following table in Oracle DB.</p>
  
  <pre><code>ID  VALUE
  -----------
  1   1  
  1   2  
  1   3   
  2   1   
  2   2  
  3   1  
  3   2  
  3   3  
  4   1
  </code></pre>
  
  <p>How can I select ID's which have all 3 values (1,2,3)</p>