November 11, 2016

The SQL Intersect operator returns distinct rows that are output by both the left and right input queries operator. SELECT expression1, expression2, … FROM tablesINTERSECTSELECT expression1, expression2, … FROM tables