A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.
Which set operator should be used?
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.
Which set operator should be used?
To find the values that are present in both tables, the INTERSECT set operator should be used. INTERSECT returns the rows that are common between the result sets of two queries, effectively providing the intersection of the two tables.
Correct
https://docs.snowflake.com/en/sql-reference/operators-query INTERSECT Returns rows from one query’s result set which also appear in another query’s result set, with duplicate elimination.