Explain UNION, MINUS, UNION ALL And INTERSECT

Explain UNION, MINUS, UNION ALL And INTERSECT


  • 24 Feb, 2012

    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.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.