INTERSECT Operator
The SQL INTERSECT operator takes the results of two queries and returns only rows that appear in both result sets. For purposes of duplicate removal the INTERSECT operator does not distinguish between NULLs. The INTERSECT operator removes duplicate rows from the final result set. The INTERSECT ALL operator does not remove duplicate rows from the final result set.
Read more about this topic: Set Operations (SQL)
Famous quotes containing the word intersect:
“One never reaches home, but wherever friendly paths intersect the whole world looks like home for a time.”
—Hermann Hesse (1877–1962)