Calculates an aggregate value of a table column.
This procedure is used to calculate an aggregate value for a table column. It can be used to apply a function to a column and get its sum, mean, average, count, minimum, maximum, standard deviation, or sample variance.
In the following examples, the column refers to the Amt column in the table below.
Note: This sample table can be generated using the create an integer table procedure.
2
150.0
200
column
table's column
The column to perform the aggregation on.
No default
Yes
aggregate function
string
The function to use for aggregation. Valid options are: sum, mean, average, count, min, max, median, std, var.
No default
Yes
aggregate value
The result of the aggregation.
100
10
30
200
5
500
get the column's countget the column's averageget the column's max