Education platform for interview prep, online tests, tutorials, and live practice

Build skills with focused learning paths, mock tests, and interview-ready content.

WithoutBook brings subject-wise interview questions, online practice tests, tutorials, and comparison guides into one responsive learning workspace.

Search the library

Prepare Interview

SQL Interview Questions and Answers

← Previous
Next →

Question: Explain UNION, MINUS, UNION ALL and INTERSECT?

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.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? Yes No

Most helpful rated by users:

What is SQL?
SQL*Plus
Date Functions
NVL
Character Functions