SQL SET OPERATIONS

SQL INTERSECT SQL INTERSECT return records which are common in all the SELECT queries involved in operation. INTERSECT only return unique value, all duplicate values are removed from final result. SELECT id1 FROM table1 INTERSECT SELECT id2 FROM table2

SQL EXCEPT SQL EXCEPT returns records from first SELECT query which are not present in any other SELECT queries. EXCEPT only return unique value, all duplicate values are removed from final result. SELECT id1 FROM table1 EXCEPT SELECT id2 FROM table2

SQL UNION UNION SET operator return unique record from all SELECT queries involved in operation.For UNION (or any Other SQL SET OPERATION) to work Number of selected columns from all SELECT queries must match. In this given code each query have one selected columns “id1” and “id2”. Data type of selected columns [...]

SQL SET OPERATIONS are directly inspired from Math’s Set theory. SQL SET OPERATIONS combine result sets from two or more SQL Queries into single result set. For SQL SET OPERATIONS