There are many SET operators (UNION,MINUS & INTERSECT) available in teradata and they work in similar fashion as the mathematical SET operations.

Teradata: SET Operators

Teradata set operators provide ways to combine similar datasets from two or more queries into a single dataset. There are many SET operators available in teradata and they work in similar way as the mathematical SET operations. These can also be used to compare 2 tables.

Some of the available operators in Teradata.
Creating Tables: Creating 2 tables with similar structure to understand the logic in details.
Table 1
CREATE MULTISET VOLATILE TABLE setoperators_1(
   id INTEGER,
   name VARCHAR(100)
)
PRIMARY INDEX(id)
ON COMMIT PRESERVE ROWS;


Table 2
CREATE MULTISET VOLATILE TABLE setoperators_2(
   id INTEGER,
   name VARCHAR(100)
)
PRIMARY INDEX(id)
ON COMMIT PRESERVE ROWS;

Populating Tables: Inserting relevant data in newly created tables for understanding logic.
Table 1:
INSERT INTO setoperators_1 VALUES(1,'Teradata');
INSERT INTO setoperators_1 VALUES(1,'Teradata');
INSERT INTO setoperators_1 VALUES(2,'Database');
INSERT INTO setoperators_1 VALUES(3,'Oracle');
INSERT INTO setoperators_1 VALUES(4,'Vertica');
INSERT INTO setoperators_1 VALUES(4,'Vertica');

Table 2:
INSERT INTO setoperators_2 VALUES(1,'Teradata');
INSERT INTO setoperators_2 VALUES(1,'Teradata');
INSERT INTO setoperators_2 VALUES(2,'Database');
INSERT INTO setoperators_2 VALUES(5,'DB2');
INSERT INTO setoperators_2 VALUES(6,'MYSQL');


Detail explanation of each operator


UNION vs UNION ALL: If there are duplicate records after combining datasets then "UNION" will filter duplicates but "UNION ALL" will return all duplicates in output result.

INTERSECT vs INTERSECT ALL: If there are duplicate records after intersecting datasets then "INTERSECT" will filter duplicates but "INTERSECT ALL" will return all duplicates in output result.

MINUS vs MINUS ALL: If there are duplicate records after subtracting 1 datasets then "MINUS" will filter duplicates but "MINUS ALL" will return all duplicates in output result.