8. List and Explain at least three other SQL Operations which an RDBMS might support.
UNION
|
Combines the results
of two unrelated queries into a single output |
|
INTERSECT
|
Similar to UNION
(Combines the results of two unrelated queries into a single output) BUT Similar to UNION
(Combines the results of two unrelated queries into a single output) |
|
DIFFERENCE |
Yields all rows in
one table NOT found in the other |
|
PRODUCT |
Produces list of all
possible pairings |