Aggregate functions

     The aggregate functions apply to a single field selection in the grid of the Columns pane. We will list all aggregate function options with the actual string that is inserted into the current cursor location in the SQL pane. Note that we will only give the MS-SQL Server versions of these insert strings leaving the Oracle or other versions to the user to experiment.

Option name in the popup list

Inserted string (where Fld is the selected field)

Average  

AVG(Fld)

Average Distinct

AVG(DISTINCT Fld)

Count

COUNT(Fld)

Count Distinct

COUNT(DISTINCT Fld)

Maximum

MAX(Fld)

Minimum

MIN(Fld)

Standard Deviation

STDEV(Fld)

Sum

SUM(Fld)

Sum Distinct

SUM(DISTINCT Fld)

Variance

VAR(Fld)