Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » Summarizing, grouping, and sorting query results » The GROUP BY clause: Organizing query results into groups


Using GROUP BY with aggregate functions

A GROUP BY clause almost always appears in statements that include aggregate functions, in which case the aggregate produces a value for each group. These values are called vector aggregates. (A scalar aggregate is a single value produced by an aggregate function without a GROUP BY clause.)