how to use the SQL Server INTERSECT operator to combine result sets of two input queries and return the distinct rows that appear in both inputs.
Shathana. S.R. Answered question
The SQL Server INTERSECT combines result sets of two or more queries and returns distinct rows that are output by both queries.
Similar to the Union operator, the queries in the syntax above must conform to the following rules:
- Both queries must have the same number and order of columns.
- The data type of the corresponding columns must be the same or compatible.
Shathana. S.R. Answered question
The SQL Server INTERSECT combines result sets of two or more queries and returns distinct rows that are output by both queries.
Similar to the Union operator, the queries in the syntax above must conform to the following rules:
- Both queries must have the same number and order of columns.
- The data type of the corresponding columns must be the same or compatible.
Vishalini.R Answered question