title: SQL - Multiple conditions where clause the same column
body: <p>I have a dataset that looks a little something like this </p>
  
  <pre><code>Subject_ID   Diagnosis_ID  
  001          299
  001          288
  001          233
  001          299
  002          299
  002          233
  003          238
  004          299
  004          233
  </code></pre>
  
  <p>I'd like to create a new new table consisting of patients that have 
  diagnosis codes 299 and 233. </p>
  
  <p>The code tried so far has been </p>
  
  <pre><code>Select *
    From mytable 
   where diagnosis_id = 299 AND diagnosis_id=233
  </code></pre>
  
  <p>This hasn't worked - </p>
  
  <p>I've also tried </p>
  
  <pre><code>Select *
    From mytable 
   where diagnosis_id = 299 
  INTERSECT
  Select *
  From mytable 
  where diagnosis_id= 233
  </code></pre>
  
  <p>This hasn't worked either. </p>