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