Nested Queries are supported.

Nested Queries are supported.

• A. Not specified
• B. True
• C. False
• D. Depends

Answer: (B)

Nested queries are supported in Marketing Cloud’s SQL used by Query Activities. You can place a SELECT inside another SELECT, typically as a subquery in the FROM clause to create a derived dataset you reference in the outer query, and you can also nest subqueries in SELECT or WHERE. This lets you pre-aggregate data, filter results, or apply complex conditions in a single query rather than multiple steps. For example, you could compute a per-subscriber total in a subquery and then select those with totals over a threshold in the outer query, or filter results by IDs produced by another subquery. While there are some engine limitations and aliasing rules to keep in mind, the ability to nest queries means the statement is true.

Nested queries are supported in Marketing Cloud’s SQL used by Query Activities. You can place a SELECT inside another SELECT, typically as a subquery in the FROM clause to create a derived dataset you reference in the outer query, and you can also nest subqueries in SELECT or WHERE. This lets you pre-aggregate data, filter results, or apply complex conditions in a single query rather than multiple steps. For example, you could compute a per-subscriber total in a subquery and then select those with totals over a threshold in the outer query, or filter results by IDs produced by another subquery. While there are some engine limitations and aliasing rules to keep in mind, the ability to nest queries means the statement is true.