Which types of subqueries does Snowflake support? (Choose two.)
Which types of subqueries does Snowflake support? (Choose two.)
Snowflake supports uncorrelated scalar subqueries in any place that a value expression can be used, as well as EXISTS, ANY / ALL, and IN subqueries in WHERE clauses, which can be either correlated or uncorrelated. These options cover the necessary types of subqueries supported by Snowflake.
BE correct Snowflake currently supports the following types of subqueries: Uncorrelated scalar subqueries in any place that a value expression can be used. Correlated scalar subqueries in WHERE clauses. EXISTS, ANY / ALL, and IN subqueries in WHERE clauses. These subqueries can be correlated or uncorrelated. https://docs.snowflake.com/en/user-guide/querying-subqueries
correct
Correct ans BE https://docs.snowflake.com/en/user-guide/querying-subqueries