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
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
No comments:
Post a Comment