Keywords in expressions
There are a number of different keywords that can be included in different types of expressions. See below for a description. The keywords are not case-sensitive.
Option | Description |
---|---|
AS
|
The
Examples:
|
CROSS
|
The
Example:
|
DISTINCT
|
The
Example:
|
ELSE
|
The
Simple:
The Arg1 expression is evaluated and when Arg1 is equal to Arg2 then Arg3 is returned. Multiple when/then expressions can be entered and are evaluated in left to right order. Searched:
Returns
Arg2 if
Arg1=true, and
Arg3 if
Multiple when/then expressions can be entered and are evaluated in left to right order. Examples:
|
END
|
See
|
FALSE
|
Example:
|
IS
|
Examples:
|
NEST
|
The
Example:
|
NULL
|
Examples:
|
OVER
|
Example:
|
THEN
|
The
In the post-aggregation context, the part of the expression
after the
Examples:
|
TRUE
|
Example:
|
WHEN
|
See
|