intersect交集操作

INTERSECT – 僅僅給出2個表都有的數據(去除重復記錄)

CREATE TABLE union_tab_1 (

id INT,

val VARCHAR(10)

);

CREATE TABLE union_tab_2 (

id INT,

val VARCHAR(10)

);

INSERT INTO union_tab_1 VALUES(1, 'A');

INSERT INTO union_tab_1 VALUES(2, 'B');

INSERT INTO union_tab_1 VALUES(3, 'C');

INSERT INTO union_tab_2 VALUES(1, 'A');

INSERT INTO union_tab_2 VALUES(1, 'A');

INSERT INTO union_tab_2 VALUES(2, 'B');

INSERT INTO union_tab_2 VALUES(4, 'D');

SQL> SELECT * FROM union_tab_1

2 INTERSECT

3 SELECT * FROM union_tab_2;

ID VAL

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

1 A

2 B

上一篇:某強湧浪指數公式的源代碼

下一篇:茅臺1935是壹箱壹碼的嘛