SQL INTERSECT

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL INTERSECT - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL INTERSECT statement. Write SQL syntax for the SQL INTERSECT statement along with an example.

SQL INTERSECT allows combining results of two or more select queries. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results.

Syntax:
Select field1, field2, . field_n from tables INTERSECT select field1, field2, . field_n from tables;

Example:
Select salary from employee INTERSECT select salary from manager;

<<Previous  Next>>