Informatics Practices
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.
SQL Joins & Grouping
3 Likes
Answer
MINUS
Answered By
1 Like
Related Questions
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:
_________ returns all rows from both the SELECT queries after removing duplicate rows between the two SELECT statements.
Fill in the blanks:
The INTERSECT operation can be simulated in MySQL using _________ JOIN.
Non-equi-join is the name of Natural join.