Contents Index Indexed group by Sorting and unions

ASA SQL User's Guide
  Query Optimization and Execution
    Query execution algorithms
      Grouping

Single group by

When no GROUP BY is specified, a single row aggregate is produced.

Contents Index Indexed group by Sorting and unions