EXCEPT in Teradata

EXCEPT is a set operation which retrieves the rows from main table which are not in the secondary table.
It is same as that of MINUS but it is ANSI compliant and MINUS is Teradata compliant.

Code:
SELECT * main_table
EXCEPT
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