SQL MINUS - Introduction and syntax
SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai
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
|