title: Filter from same table in Oracle
body: <p>I have a table and I want to filter result from same table. Here is a sample.</p>
  
  <pre><code>STUDENT_ID | SCHOOL_YEAR |
  -----------+-------------+
  747        | 20122013    |
  747        | 20132014    |
  748        | 20122013    |
  749        | 20122013    |
  749        | 20132014    |
  750        | 20122013    |
  751        | 20112012    |
  </code></pre>
  
  <p>I want to sort the table so that only those student_id show up who has 20122013 school year but NOT 20132014.</p>
  
  <p>So the result would be</p>
  
  <pre><code>STUDENT_ID | 
  -----------+
  748        |
  750        |
  </code></pre>
  
  <p>I tried to UNION and LEFT/RIGHT JOIN but no luck.</p>
  
  <p>Please help. Thanks.</p>