Logical Operators and Conditional and Subquery Expressions
Logical Operator Support
Conditional Expression Support
Geospatial and array column projections are not supported in the COALESCE
function and CASE expressions.
Subquery Expression Support
Usage Notes
You can use a subquery anywhere an expression can be used, subject to any runtime constraints of that expression. For example, a subquery in a CASE statement must return exactly one row, but a subquery can return multiple values to an IN expression.
You can use a subquery anywhere a table is allowed (for example,
FROM
subquery), using aliases to name any reference to the table and columns returned by the subquery.
Last updated