You can prove equivalence for yourself using the minus operator. Replace “select 1” and “select 2” with your queries.
Select * from (
(Select 1)
Minus
(Select 2)
)
——
Select * from (
(Select 2)
Minus
(Select 1)
)
You can prove equivalence for yourself using the minus operator. Replace “select 1” and “select 2” with your queries.
Select * from (
(Select 1)
Minus
(Select 2)
)
——
Select * from (
(Select 2)
Minus
(Select 1)
)