4D v13.4in_predicate |
||||||||||||||
|
4D v13.4
in_predicate
in_predicate
An in_predicate is used to compare an arithmetic_expression to check whether it is included (or NOT included if this keyword is also passed) in a list of values. The list of values used for the comparison can either be a sequence of arithmetic expressions that are passed or the result of a subquery. This example selects the records of the ORDERS table whose order_id column value is equal to 10000, 10001, 10003 or 10005: SELECT * |
PROPERTIES
Product: 4D INDEX SEE ALSO
arithmetic_expression |
||||||||||||