Explain Union, Minus, Union All And Intersect?

1.	Explain Union, Minus, Union All And Intersect?
Answer» INTERSECT - returns all distinct rows SELECTED by both queries. MINUS - returns all distinct rows selected by the first query but not by the SECOND. UNION - returns all distinct rows selected by either query UNION ALL - returns all rows selected by either query, including all duplicates. INTERSECT - returns all distinct rows selected by both queries. MINUS - returns all distinct rows selected by the first query but not by the second. UNION - returns all distinct rows selected by either query UNION ALL - returns all rows selected by either query, including all duplicates.

Answer»

INTERSECT - returns all distinct rows SELECTED by both queries.
MINUS - returns all distinct rows selected by the first query but not by the SECOND.
UNION - returns all distinct rows selected by either query
UNION ALL - returns all rows selected by either query, including all duplicates.

INTERSECT - returns all distinct rows selected by both queries.
MINUS - returns all distinct rows selected by the first query but not by the second.
UNION - returns all distinct rows selected by either query
UNION ALL - returns all rows selected by either query, including all duplicates.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Components Of Logical Database Structure Of Oracle Database?
What Is A Tablespace?
What Is System Tablespace And When Is It Created?
Explain The Relationship Among Database, Tablespace And Data File.
What Are Schema Objects?
Can Objects Of The Same Schema Reside In Different Tablespaces?
Can A Tablespace Hold Objects From Different Schemes?
What Is Oracle Table?
What Is An Oracle View?
Do A View Contain Data?