Below are several examples using the following data:
Code: Select all
dbadmin=> SELECT name FROM dba_team;
name
--------
Peng C
Jim K
Tom L
Pat K
(4 rows)
Code: Select all
dbadmin=> SELECT name FROM bi_team;
name
-----------
Dan J
Jessica D
Jerry M
Bill K
Tom K
Susan Y
Jessica W
Jim K
(8 rows)
Code: Select all
dbadmin=> SELECT name FROM dba_team
dbadmin-> INTERSECT
dbadmin-> SELECT name FROM bi_team;
name
-------
Jim K
(1 row)
Code: Select all
dbadmin=> SELECT name FROM bi_team
dbadmin-> MINUS
dbadmin-> SELECT name FROM dba_team;
name
-----------
Bill K
Dan J
Jerry M
Jessica D
Tom K
Jessica W
Susan Y
(7 rows)
Code: Select all
dbadmin=> SELECT name FROM dba_team
dbadmin-> EXCEPT
dbadmin-> SELECT name FROM bi_team;
name
--------
Peng C
Pat K
Tom L
(3 rows)