MINUS in Teradata

MINUS is a set operation which retrieves the rows from main table which are not in the secondary table.

Code:
SELECT * main_table
MINUS
SELECT * secondary_table

The records in the main_table which are not present in the secondary table will be the result.

Suppose main_table has the following rows,
idnamesalary
1Joe25000
2Fuller45000
3Christopher33000

secondary_table has following rows,
idnamesalary
1Joe25000
2Fuller45000


The result will be
idnamesalary
3Christopher33000