I have a table and I want to filter result from same table. Here is a sample.

```
STUDENT_ID | SCHOOL_YEAR |
-----------+-------------+
747        | 20122013    |
747        | 20132014    |
748        | 20122013    |
749        | 20122013    |
749        | 20132014    |
750        | 20122013    |
751        | 20112012    |

```

I want to sort the table so that only those student\_id show up who has 20122013 school year but NOT 20132014.

So the result would be

```
STUDENT_ID | 
-----------+
748        |
750        |

```

I tried to UNION and LEFT/RIGHT JOIN but no luck.

Please help. Thanks.