Certain rules and restrictions apply to SELECT statements connected by set operators that might not apply elsewhere.