Vector and Scalar Aggregation

Adaptive Server 15.0.2 supports vector and scalar aggregation

In vector aggregation, the SPJ result set is grouped on the group by clause expressions, and then the select clause aggregation functions are applied to each group. The query produces one result row per group:

select r1, sum (s1)
from r, s
where r2 = s2
group by r1

In scalar aggregation, there is no group by clause and the entire SPJ result set is aggregated, as a single group, by the same select clause aggregate functions. The query produces a single result row:

select sum (s1)
from r, s
where r2 = s2