Page 1 of 1
Which statement is true about the INTERSECT operator used in compound queries?
Posted: Sun Jun 11, 2023 3:55 pm
by answerhappygod
Which
statement is true about the INTERSECT operator used in compound queries?
A. Multiple INTERSECT operators are not possible in the same SQL
statement
B. It processes NULLs in the selected columns
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. It ignores NULLs