关闭

SQL 查询中的并(Union)、交(Intersect)、差(Minus)

标签: sqlduplicatescommandfeaturesoracle数据库
1748人阅读 评论(0) 收藏 举报
分类:

在数据库的数据集操作中经常碰到大量的数据进行集合操作,这里面有几个比较重要的集合操作,对SQL的性能有较大的帮助。下面就是这几个操作语句的介绍。

UNION Statement

Combine data from one or more SELECT statements.

In Oracle 8i (and above) the UNION command has been largely replaced by the new Analytic Features

Syntax:

SELECT command  {UNION | UNION ALL | INTERSECT | MINUS} SELECT command

key:

UNION - Combine the unique rows returned by 2 SELECT statements

UNION ALL - Combine the rows returned by 2 SELECT statements (including all duplicates)

INTERSECT - Return only those rows that are in *both* SELECT statements

MINUS - Return the rows that are in the first SELECT but not the second

To combine more than two SELECTs simply nest the expressions

SELECT expr1 UNION (SELECT expr2 UNION SELECT expr3) 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:789089次
    • 积分:10341
    • 等级:
    • 排名:第1614名
    • 原创:237篇
    • 转载:184篇
    • 译文:0篇
    • 评论:175条
    最新评论