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...