Basically set operators are used to join two statements. There are various types of set operators are available. Here are few set operators.
- UNION operators : You will get single result with combination of two SELECT statements. But this operator removes duplicate values from the result.
- UNION ALL : This operator little bit different from UNION operator as it retains duplicate value in the result.
- INTERSECT : This operator used to list all the records which are common in SELECT queries.
- MINUS : This operator return all the available rows from first SELECT which are not found in second statement.