Content

Target customers: developers and analysts. Features released: MaxCompute SQL is compatible with the syntax of PostgreSQL subqueries. You can use the syntax of multi-column operations in an IN subquery or scalar subquery. IN subquery: The value of the IN expression in the WHERE clause can be multiple columns of SELECT statements or multiple constants. The value can also contain aggregate functions. Scalar subquery: The following multi-column scenarios are supported: 1. The SELECT statement contains multiple columns of scalar subqueries, which must be equivalent expressions. 2. The SELECT statement contains multiple columns of Boolean expressions for equivalent comparison. 3. The WHERE clause contains multiple columns of equivalent expressions.