SQL UNION

QL UNION is query that allows you to select related information from 2 tables, this is combine 2 SELECT statement into 1 and display it out.

UNION will only return DISTINCT value only. Which means will eliminate duplicate records that returned.

There are some condition that need to meet when using the UNION statement.
First SELECT statement must have the same column number if compare with 2nd SELECTStatement.
Data type also has to be same for both columns to combine.

The syntax is as follows:

SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 1]
UNION
SELECT [COLUMN NAME 1], [COLUMN NAME 2],… FROM [TABLE NAME 2]


EXAMPLE :

We have 2 table name GamesScores, GameScores_new.

Table GameScores

PlayerNameDepartmentScores
JasonIT3000
IreneIT1500
JaneMarketing1000
DavidMarketing2500
PaulHR2000
JamesHR2000

Table GameScores_new

PlayerNameDepartmentScores
JasonIT3000
DavidMarketing2500
PaulHR2000
JamesHR2000

SQL statement :

SELECT PlayerName FROM GameScores
UNION
SELECT PlayerName FROM GameScores_new

Result:

PlayerName
David
Irene
James
Jane
Jason
Paul
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值