SQL MINUS - Introduction and syntax

Explain the SQL MINUS statement. Write SQL syntax for the SQL MINUS statement along with an example.

SQL MINUS returns all rows in the first query that are not returned in the second query. Each statement must have the same number of fields in the result sets with similar data types.

Syntax:
Select field1, field2, . field_n from tables MINUS select field1, field2, . field_n from tables;

Example:
Select salary from employee MINUS select salary from manager