4D v14

in_predicate

Home

 
4D v14
in_predicate

in_predicate  


 

 

Command in_predicatarithmetic_expression [NOT] IN (subquery) |

arithmetic_expression [NOT] IN (arithmetic_expression, ..., arithmetic_expression)

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.

Example  

This example selects the records of the ORDERS table whose order_id column value is equal to 10000, 10001, 10003 or 10005:

SELECT *
FROM ORDERS
WHERE order_id IN (10000, 10001, 10003, 10005);

 
PROPERTIES 

Product: 4D
Theme: Syntax rules

 
SEE ALSO 

arithmetic_expression
predicate

 
ARTICLE USAGE

4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)