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) |