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



You may also read following recent Post

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links