Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 37 of 91

JOINS and SET Operations — Question 13

Back to all questions
13
Question

Question 13

What is the correct statement for describing the EXCEPT operation ?

  1. It excludes all the rows present in both the queries
  2. It includes the rows of the second query but excludes the results of the first query
  3. It includes the rows of the first query but excludes the results of the second query
  4. It includes all the rows of both queries but removes duplicates
Answer

It includes the rows of the first query but excludes the results of the second query

Reason — The EXCEPT (or MINUS) operator in SQL is used to retrieve unique rows from the first query, specifically those rows that exist in the first query but not in the second query.