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 May 27, 2023
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 May 27, 2023
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 May 26, 2023