1, 集合运算符
UNION
--All rows selected by either query
--包含两者的所有记录,相同的只取一个,相当于distinct
UNION ALL
--All rows selected by either query, including all duplicates
--包含两者的所有记录,A+B
INTERSECT
--All distinct rows selected by both queries
--A和B的交集
MINUS
--All distinct rows selected by the first query but not the second
--A-B