# 其他集合运算

__*EXCEPT*__
__*INTERSECT*__

+ TiDB 还支持另外两种集合运算:差集 (`EXCEPT`) 和交集 (`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 |
+------+
```