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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Summarizing, Grouping, and Sorting Query Results » Standards and compatibility

Standards and compatibility Next Page

GROUP BY and the SQL/2003 standard

The SQL/2003 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.

SQL 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.