Sets, SQL Simantics

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

Randy Sims SQL Server

Did you know you can do set-based math with SQL Server? With the UNION, INTERSECT, and EXCEPT set operators, you can compare one result set to another and add or subtract results, called a compound query. This can be a handy tool for your toolbox. This is very similar to Oracle Set Operators: UNION, INTERSECT and MINUS

Oracle Set Operators: UNION, INTERSECT and MINUS

Randy Sims SQL Fundamentals I

Did you know you can do set-based math with Oracle? With the UNION, INTERSECT and MINUS set operators, you can compare one result set to another and add or subtract results, called a compound query. This can be a handy tool for your toolbox.