All Products
Document Center


Last Updated: Jun 18, 2021

Expressions are generalized notions. Each expression contains several input parameters and returns an output result. An input parameter may be a constant or a single row of data, or multiple rows of data. Expressions can be combined. The input of one expression can be the output of another expression.

Expressions can be divided into the following categories based on the source and form:

  • Column reference

  • Constant

  • Operator

  • Function


SELECT ABS(a + 1) 
  FROM t1 
 WHERE a > 0;

  • a is a column reference.
  • 0 and 1 are constants.
  • > and + are operators that take 0, 1, and the a expression as input.
  • ABS is a function that takes the + expression as input.