# Other Set Operations

+ `TiDB` also supports two other set operations: **`EXCEPT`** and **`INTERSECT`**
```
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 |
+------+
```

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