Respuesta :
The intersect statement can be used to combine rows from two queries, returning only the rows that appear in both sets.
What is the function of INTERSECT operation?
- The intersect operation returns the intersection of the results of the results of two different queries which have the same set of attributes in the select clause. It automatically eliminates duplicates.
- SQL INTERSECT operator combines two select statements and returns only the dataset that is common in both the statements. To put it simply, it acts as a mathematical intersection.
- INTERSECT compares the data between tables and returns only the rows of data that exist in both tables whereas MINUS compares the data between tables and returns the rows of data that exist only in the first table you specify.
- Rows from two queries can be combined using the intersect command, which only returns rows that are present in both sets.
To learn more about intersect operation, refer
https://brainly.com/question/28338910
#SPJ4
