Aggregate functions

The aggregate functions generate summary values that appear as new columns in the query results.

Table 3-2: Server class support for aggregate functions

Function

ASE

ASA

ASIQ

dir_con

avg

Y

Y

Y

C

count

Y

Y

Y

C

max

Y

Y

Y

C

min

Y

Y

Y

C

sum

Y

Y

Y

C

count_big

Y

N

N

N