Which statement is true regarding the INTERSECT operator?

Which statement is true regarding the INTERSECT operator?

Which statement is true regarding the INTERSECT operator?

A.
It ignores NULL values.

B.
Reversing the order of the intersected tables alters the result.

C.
The names of columns in all SELECT statements must be identical.

D.
The number of columns and data types must be identical for all SELECT statements in the query.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Sue

Sue

“A” is also true. Any comment?

Justyna

Justyna

From SQl Fundamentals I

“Intersect does not ignore NULL values”