sql交集、差集、并集

1.并集

SELECT Name FROM Person_1
  UNION
  SELECT Name FROM Person_2

2.交集

SELECT Name FROM Person_1
  INTERSECT
  SELECT Name FROM Person_2


3.差集

SELECT Name FROM Person_1
  EXCEPT
  SELECT Name FROM Person_2
 
posted @ 2015-08-24 17:44  锋利的C#  阅读(393)  评论(0编辑  收藏  举报