What is SQL Intersect ??
By Rizwan Saqib   Posted on March-21-2018 689
MS Sql Server
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;
By Rizwansaqib966   21-Mar-2018
Views 689