Home » MCQs » SQL MCQs » SQL EXCEPT Clause MCQs

Select the correct rule of SQL EXCEPT

3. Select the correct rule of SQL EXCEPT.

1. There must be the same number of columns in each table and the same order in every select statement.
2. It is desirable that the columns have similar or compatible data types.
3. Both SELECT statements must have the same fields in their respective columns.
4. All of the above

Answer: D) All of the above

Explanation:

Rules of SQL EXCEPT are:

1. There must be the same number of columns in each table and the same order in every select statement.
2. It is desirable that the columns have similar or compatible data types.
3. Both SELECT statements must have the same fields in their respective columns.