The row aggregates used with compute are listed in Table 3-2:
Row aggregates |
Result |
---|---|
sum |
Total of the values in the expression |
avg |
Average of the values in the expression |
max |
Highest value in the expression |
min |
Lowest value in the expression |
count |
Number of selected rows as an integer |
count_big |
Number of selected rows as a bigint |
These row aggregates are the same aggregates that can be used with group by, except there is no row aggregate function that is the equivalent of count(*). To find the summary information produced by group by and count(*), use a compute clause without the by keyword.