Informatics Practices
Fill in the blanks:
An _________ query returns the intersection of 2 or more tables.
SQL Joins & Grouping
2 Likes
Answer
INTERSECT
Answered By
2 Likes
Related Questions
Fill in the blanks:
_________ join is a reversed version of the left join.
Fill in the blanks:
_________ join produces a data set that includes only those rows from the left table which have matching rows from the right table.
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.