CBSE Class 12 Informatics Practices Question 14 of 91

JOINS and SET Operations — Question 6

Back to all questions
6
Question

Question 6

How is INTERSECT different from MINUS operation ?

Answer

In SQL, the INTERSECT operator returns rows common to two tables, while the MINUS (EXCEPT) operator retrieves unique rows from the first table that are not in the second table.