SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

Explain UNION, MINUS, UNION ALL and INTERSECT?

SQL Interview Question
SQL Interview Question

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.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Explain CONNECT BY PRIOR?What is the fastest way of accessing a row in a table?