Collection Contents Index The UNION operation: combining queries CHAPTER 6.  Joins: Retrieving Data from Several Tables pdf/chap5.pdf

User's Guide
   PART 1. Working with Databases
     CHAPTER 5. Summarizing, Grouping, and Sorting Query Results       

Standards and compatibility


This section describes standards and compatibility aspects of the Adaptive Server Anywhere GROUP BY clause.

Top of page  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 and one summary 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.

Top of page  Compatibility with Adaptive Server Enterprise

Adaptive Server Enterprise supports several extensions to the GROUP BY clause that are not supported in Adaptive Server Anywhere. These include the following:

Top of page  

Collection Contents Index The UNION operation: combining queries CHAPTER 6.  Joins: Retrieving Data from Several Tables pdf/chap5.pdf