GBase UP 产品手册 5 数据库管理指南 文档版本04(2021-04-21) 南大通用数据技术股份有限公司 731 示例 示例1:SELECT ... INTERSECT SELECT ... 示例中用到的表及数据: USE test; CREATE TABLE t1 (a int , b varchar(10)); CREATE TABLE t2 (c int ,d varchar(20),e varchar(5)); INSERT INTO t1 VALUES(1,'a'),(2,'b'),(3,'c'); INSERT INTO t2 VALUES(1,'a','aa'),(2,'b','bb'),(4,'c','cc'); 示例: gbase> SELECT a ,b FROM t1; +------+------+ | a | b | +------+------+ | 1 | a | | 2 | b | | 3 | c | +------+------+ 3 rows in set
gbase> SELECT c AS a, d AS b FROM t2; +------+------+ | a | b | +------+------+ | 1 | a | | 2 | b | | 4 | c | +------+------+ 3 rows in set
gbase> SELECT a ,b FROM t1 INTERSECT SELECT c AS a, d AS b FROM t2; +------+------+ | a | b | +------+------+ | 1 | a | | 2 | b | +------+------+ 2 rows in set
GBase UP 产品手册 5 数据库管理指南 文档版本04(2021-04-21) 南大通用数据技术股份有限公司 732