User guide

Operator reference
110 Data Integration with Sybase Avaki Studio
 Function: Click the Function field and use the pull down list to choose the func-
tion you want to use for this column. The value of the Expression field will be
passed to this function for each row in the incoming result set. The functions are
described under “Aggregate functions” below.
 Type: Specify the type of the column. Be sure to specify a numeric type (INTE-
GER
, for example) for aggregate columns that use the Count function.
 Precision: Specify the precision for the column, if applicable for the column’s
type.
 Scale: Specify the scale for the column, if applicable for the column’s type.
Aggregate functions
The table below lists the available aggregation functions and describes what they do.
Function Description
Sum Adds the value of expression for each row to obtain a total.
Average Averages the values of
expression for each row—equivalent to
using Sum and dividing by Count.
Maximum Returns the highest value of
expression from the input result
set.
Minimum Returns the lowest value of
expression from the input result
set.
Count Returns the number of rows in the input result set. The value of
expression is ignored. Note that this will return an integer
regardless of the type of the expression.
First Returns the value of
expression for the first row in the input
result set.
Last Returns the value of
expression for the last row in the input
result set.
Population variance Returns the population variance for the values of
expression in
the input result set.
Sample variance Returns the sample variance for the values of
expression in the
input result set.