Please send your Questions & Answers or Feedback to "mohan@javabook.org"

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.
Related Posts Plugin for WordPress, Blogger...
Flag Counter