§ Oracle兼容-语法-MINUS
§ 1. 语法
SELECT ...
MINUS SELECT ...
[MINUS SELECT ...]
1
2
3
2
3
§ 2. 定义和用法
MINUS 语法的作用是对两个结果集进行差集计算，不包括重复行。其用法类似 UNION、INTERSECT 语法。
用法同 UNION 操作，不支持右子树嵌套 MINUS，如下例所示：
greatsql> SELECT 1 minus (SELECT 1 MINUS SELECT 1);
ERROR 1235 (42000): This version of MySQL doesn't yet support 'nesting of unions at the right-hand side'
1
2
2
§ 3. 示例
greatsql> SELECT 1,2 MINUS SELECT 'a','b';
+---+---+
| 1 | 2 |
+---+---+
| 1 | 2 |
+---+---+
greatsql> SELECT 1,2 MINUS SELECT 1,2;
Empty set (0.00 sec)
greatsql> CREATE TABLE t1(c1 INT);
greatsql> INSERT INTO t1 VALUES (1),(2),(3),(3);
greatsql> CREATE TABLE t2(c1 INT);
greatsql> INSERT INTO t2 VALUES (1),(2);
greatsql> SELECT * FROM t1 MINUS SELECT * FROM t2;
+------+
| c1 |
+------+
| 3 |
+------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
扫码关注微信公众号
