当前位置: 首页 > 网络学院 > 服务端脚本教程 > SQL > SQL Union

SQL
SQL 介绍
SQL Select
SQL Where 子句
SQL Insert
SQL Update
SQL Delete
SQL 技能测试
SQL Order By
SQL 与 & OR
SQL In
SQL Between
SQL Aliases
SQL Join
SQL Union
SQL Create
SQL Drop
SQL Alter
SQL 函数
SQL Group By
SQL Select Into

SQL Union


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-03-01   浏览: 914 ::
收藏到网摘: n/a

UNION

The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type.
UNION命令可以用来选择两个有关联的信息,和JOIN命令非常相似。然而当使用UNION命令时得保证所选择的栏目数据类型相同。

Note: With UNION, only distinct values are selected.
注意:使用UNION,只有不同的值会被选择出来。

SQL Statement 1
UNION
SQL Statement 2


Employees_Norway表:

E_ID E_Name
01 Hansen, Ola
02 Svendson, Tove
03 Svendson, Stephen
04 Pettersen, Kari

Employees_USA表:

E_ID E_Name
01 Turner, Sally
02 Kent, Clark
03 Svendson, Stephen
04 Scott, Stephen


Using the UNION Command
使用UNION 命令

Example
举例

List all different employee names in Norway and USA:
列举在USA和Norway中不同的人员名字:

SELECT E_Name FROM Employees_Norway
UNION
SELECT E_Name FROM Employees_USA

Result
结果

E_Name
Hansen, Ola
Svendson, Tove
Svendson, Stephen
Pettersen, Kari
Turner, Sally
Kent, Clark
Scott, Stephen

Note: This command cannot be used to list all employees in Norway and USA. In the example above we have two employees with equal names, and only one of them is listed. The UNION command only selects distinct values.
注意:这个命令不能将Norway和USA中所有的人员列举出来。在上面的举例中两个表有相同人员名字的数据,最后列出来的只会是其中的一个。


UNION ALL

The UNION ALL command is equal to the UNION command, except that UNION ALL selects all values.
UNION ALL命令等同于UNION命令,但UNION ALL会选择全部的值

SQL Statement 1
UNION ALL
SQL Statement 2


Using the UNION ALL Command
使用 UNION ALL命令

Example举例

List all employees in Norway and USA:
列举出在Norway和USA中所有的员工:

SELECT E_Name FROM Employees_Norway
UNION ALL
SELECT E_Name FROM Employees_USA

Result
结果

E_Name
Hansen, Ola
Svendson, Tove
Svendson, Stephen
Pettersen, Kari
Turner, Sally
Kent, Clark
Svendson, Stephen
Scott, Stephen

评论 (0) All

登陆 | 还没注册?