Computer scienceFundamentalsSQL and DatabasesBasics SQLFunctions and operations

Set operations

Report a typo

Match these set operations with their definitions.

Match the items from left and right columns

UNION

UNION ALL

INTERSECT

MINUS

Return all distinct rows selected by both queries

Return all distinct rows selected by either query

Return all rows selected by either query

Return all rows returned by first SELECT statement that are not returned by the second one

___

Create a free account to access the full topic