Title: Describe the use of the INTERSECT operator. Post by: S3odz on Jan 30, 2018 Describe the use of the INTERSECT operator.
Title: Describe the use of the INTERSECT operator. Post by: grfrfvfbvr on Jan 30, 2018 INTERSECT yields only the rows that appear in both tables. As with UNION, the tables must be union-compatible to yield valid results. For example, you cannot use INTERSECT if one of the attributes is numeric and one is character-based. For the rows to be considered the same in both tables and appear in the result of the INTERSECT, the entire rows must be exact duplicates.
|