SQL INTERSECT

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

INTERSECT produces rows that appear in both queries.that means INTERSECT command acts as an AND operator (value is selected only if it appears in both statements).

The syntax is as follows:

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

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

EXAMPLE :

We have 2 table name GamesScores, GameScores_new.

Table GameScores

PlayerName Department Scores
Jason IT 3000
Irene IT 1500
Jane Marketing 1000
David Marketing 2500
Paul HR 2000
James HR 2000

Table GameScores_new

PlayerName Department Scores
Jason IT 3000
David Marketing 2500
Paul HR 2000
James HR 2000

SQL statement :

SELECT PlayerName FROM GameScores

INTERSECT

SELECT PlayerName FROM GameScores_new

Result:

PlayerName
David
James
Jason
Paul
上一篇:iframe的自适应


下一篇:IOS 保存图片至相册