# Other Set Operations
__*EXCEPT*__
__*INTERSECT*__
+ TiDB also supports two other set operations: `EXCEPT` and `INTERSECT`
```8
tidb> SELECT id FROM test.a EXCEPT SELECT id FROM test.c;
+------+
| id   |
+------+
|    ~!@3@!~ |
+------+
tidb> SELECT id FROM test.c EXCEPT SELECT id FROM test.a;
+------+
| id   |
+------+
|    ~!@4@!~ |
+------+
tidb> SELECT id FROM test.d EXCEPT SELECT id from test.a;
+------+
| ID   |
+------+
|    5 |
| ~!@NULL@!~ |
+------+
tidb> (SELECT ID FROM test.d except select id from test.a) ORDER BY ID;
+------+
| ID   |
+------+
| ~!@NULL@!~ |
|    5 |
+------+
```

------------------------------------------------------------