The aggregate functions generate summary values that appear as new columns in the
query results.
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
|