Informatics Practices
Fill in the blanks:
_________ returns all rows from both the SELECT queries after removing duplicate rows between the two SELECT statements.
Related Questions
Fill in the blanks:
An _________ query returns the intersection of 2 or more tables.
Fill in the blanks:
_________ _________ returns all rows from both the SELECT queries and it does not remove duplicate rows between the various SELECT statements.
Fill in the blanks:
The _________ operation combines results of two SELECT statements and returns only those rows in the final result, which belong to the first set of the result.
Fill in the blanks:
The INTERSECT operation can be simulated in MySQL using _________ JOIN.