INTERSECT Operator in SQL

It returns all rows common to multiple queries.

Syntax:
<Component query>
INTERSECT
<Compnent query>;

Key points:
Reversing the order of component queries does not result a change in output.
NULL values are not ignored.

Example:
SELECT job FROM emp WHERE deptno = 10
INTERSECT
SELECT job FROM emp WHERE deptno = 20;

-- The above query display the common job in 10th and 20th departments.

click on for practice questions
click on for interview questions