Duality between Set and Join Operators For two tables A and B with the same columns, set intersection select * from A intersect select * from B can be expressed as a semi-join select distinct * from A where (col1,col2,…) in (select col1,col2,… from B) Likewise, set difference...
See more
Download the Study24x7 App, so you can connect and collaborate.