Friday, 2 November 2012

Explain UNION, MINUS, UNION ALL and INTERSECT? | Oracle 10g Interview Questions

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.

No comments: