// Combine result and eliminate duplicate rows
<Select clause>
UNION
<Select clause>
// returnall rows
<Select clause>
UNION ALL
<Select clause>
// return only unique rows by the first query but not by the second
<Select clause>
MINUS
<Select clause>
// return only rows by both queries
<Select clause>
INTERSECT
<Select clause>