Multi-row Boolean operator | Operand data types | Default template | Remarks |
EXISTS | <TABLE> | EXISTS $P0 | |
IN | <INTEGER>, <TABLE> <DECIMAL>, <TABLE> <DOUBLE>, <TABLE> <VARCHAR>, <TABLE> <TIMESTAMP>, <TABLE> | $P0 IN $P1 | |
NOT IN | $P0 NOT IN $P1 | Use NOT_IN as FunctionName for NOT IN. | |
< ANY | $P0 < ANY $P1 | Use LT_ANY as FunctionName for < ANY. | |
> ANY | $P0 > ANY $P1 | Use GT_ANY as FunctionName for > ANY. | |
<= ANY | $P0 <= ANY $P1 | Use LE_ANY as FunctionName for <= ANY. | |
>= ANY | $P0 >= ANY $P1 | Use GE_ANY as FunctionName for >= ANY. |