Contents Index Standards and compatibility Compatibility with Adaptive Server Enterprise

ASA SQL User's Guide
  Summarizing, Grouping and Sorting Query Results
    Standards and compatibility

GROUP BY and the SQL/92 standard


The SQL/92 standard for GROUP BY requires the following:

The results of a standard GROUP BY with vector aggregate functions produce one row with one value per group.

Adaptive Server Anywhere and Adaptive Server Enterprise support extensions to HAVING that allow aggregate functions not in the select list and not in the GROUP BY clause.


Contents Index Standards and compatibility Compatibility with Adaptive Server Enterprise