Explain UNION,MINUS,UNION ALL, INTERSECT ?

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 queryUNION ALL - returns all rows selected by either query, including all duplicates.

Interview Candidate
Sep 7th, 2004
3
5518

SQL Plus

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 8th, 2006

union: distinct result set of two queries.
union all : result set of two or more queries including duplicates
minus: result set of first query "-" resultset of second query
intersect : common result set of both query;