What is SQL Intersect ??
- MS Sql Server
- 805
- March-21-2018
- by Rizwan Saqib
INTERSECT
The SQL INTERSECT clause/operator is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement. This means INTERSECT returns only common rows returned by the two SELECT statements
For example
Select Product_ID From Products
Intersect
Select Product_ID From Inventory;
