class activity 27 june.pdf - Activity 1 SET OPERATORS -...

Activity 1

SET OPERATORS - UNION
IT COMBINES THE RESULTS OF TWO SELCT
STATEMENTS>
IT ELIMINATES DUPLICATE ROWS FROM THE
RESULT.
Code : Select * from First UNION
Select * from Second;

UNION
EXAMPLE
Union Example

SET OPERATORS -
UNION ALL
UNION ALL COMBINES
ALL RECORDS FROM BOTH
THE QUERIES
IT DOES NOT AVOID THE
DUPLICATE ENTRIES
Code : Select * from First
UNION ALL
Select * from Second;

Union All Example

SET
OPERATORS -
INTERSECT
• IT IS USED TO COMBINE BOTH
SELECT STAEMENTS, BUT IT ONLY
RETURNS THE RECORDS WHICH
ARE COMMON FROM BOTH
SELECT STATEMENTS.
• Code : Select * from First
INTERSECT Select * from Second;

INTERSECT EXAMPLE
Intersect Example

SET OPERATORS -
MINUS
• IT DISPLAYS THE ROWS WHICH
ARE PRESENT IN THE FIRST
QUERY BUT ABSENT IN THE
SECOND QUERY WITH NO
DUPLICATED
•