Home » MCQs » SQL MCQs » SQL EXCEPT Clause MCQs

Select the correct syntax of SQL EXCEPT

4. Select the correct syntax of SQL EXCEPT.

1. SELECT Column1 FROM Table1
   SELECT Column2 FROM Table2
   EXCEPT;

2. EXCEPT
   SELECT Column1 FROM Table1
   SELECT Column2 FROM Table2;

3. SELECT Column1 FROM Table1
   EXCEPT
   SELECT Column2 FROM Table2;

4. None of the above

Answer: C)

Explanation:

The correct syntax of SQL EXCEPT is,

SELECT Column1 FROM Table1
EXCEPT
SELECT Column2 FROM Table2;