Multiple choice technology databases

Which one will get higher priority

  1. Union

  2. Intersect

  3. Minus

  4. None of above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Set operations UNION, INTERSECT, and MINUS (or EXCEPT) all have equal precedence in SQL. They are evaluated left to right when chained together. None of them has higher priority than the others, making 'None of above' the correct answer.