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

Can You Import Objects From Oracle Version 7.3 To 9i?
Suppose A Column Has Many Repeated Values. Which Type Of Index You Should Create On This Column?
If A Table Has Few Rows, Should You Create Indexes On This Table?
How Do You Capture An Exception In Oracle?
What Is Recursive Sql?
What Are Different Types Of Cursors?
Can You Pivot The Results Of A Query?
What Is Null?
What Is Execute Immediate?
What Is A Database Link? What Is The Difference Between A Public And A Private Database Link? What Is A Fixed User Database Link?