F Expressions

An expression is a combination of one or more values, parameters, and functions that evaluate to a value or to a boolean result (Example: True or False).

Syntax

expression_list ::= '[' expression [, expression]… ']'
expression ::= value_returned_expression | boolean_returned_expression | '(' expression ')'

Note:

'(' <expression ')' implies nested functions. Example: MAX(AVG(salary))

Example

MAX(AVG(CUSTOMERS.CUST_CREDIT_LIMIT))