Which statement is true about the INTERSECT operator used in compound queries?
Multiple INTERSECT operators are not possible in the same SQL statement
It processes NULLs in the selected columns
INTERSECT is of lower precedence than UNION or UNION ALL
It ignores NULLs
Submit