SQL INTERSECT
2024-08-25 03:45:15
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 |
最新文章
- cd命令
- (转)Android开发出来的APP在手机的安装路径是?
- 迅为顶级四核开发板 Exynos4412开发板,仅售560元
- form 转json,将form表单中的数据序列化数组后转换为Json
- Java IO之File
- UI5_UIAlertView与UIActionSheet
- php discuz框架接口不能正常访问的问题
- C#中哈希表与List的比较
- 转载:Python中的new style class机制实现
- Label设置行间距--b
- ArcGis(01)——地图切片以及发布底图服务
- mac 系统开发android,真机调试解决方式(无数的坑之后吐血总结)
- Jquery发送ajax请求以及datatype参数为text/JSON方式
- Linux Ubuntu 14.04安装LAMP(Apache+MySQL+PHP)网站环境
- Hibernate---基础配置
- 运营商级NAT(Carrier-grade NAT)
- WPF第三方控件Telerik
- IdentityServer(11)- 使用Hybrid Flow并添加API访问控制
- 同一台机器上多个tomcat启动造成的内存溢出问题的解决方法。
- 我是如何将博客转成PDF的