Skip to content

Expressions

Overview

An expression is a combination of one or more values, operators and SQL functions that evaluate to a value. You can also use them to query the database for a specific set of data.

Remarks

Expressions can consist of multiple SQL functions. The following functions are available;

Value Description
Count Count of row values.
CountDistinct Count of distinct values in rows.
Sum Sum of row values. Valid for numeric type columns.
SumDistinct Sum of distinct values in rows. Valid for numeric type columns.
Avg Average of row values. Valid for numeric type columns.
AvgDistinct Average of distinct values in rows. Valid for numeric type columns.
Min Minimum value in rows.
Max Maximum value in row values.
StdDev Standard deviation of row values.
DateDiff Difference between two date values. Valid for date and datetime type columns.
DatePart Crops out the specified part of date values and gives the kept part as number value. Valid for date and datetime type columns.
DateTrunc Truncates date values except the specified date part and gives a date value. Valid for date and datetime type columns.