GROUP BY ALL support is as follows:
Adaptive Server Enterprise supports GROUP BY ALL, which returns all possible groups including those eliminated by the WHERE clause and HAVING clause. These have the NULL value for all aggregates.
SQL Anywhere does not support the GROUP BY ALL Transact-SQL extension.
ROLLUP and CUBE in the GROUP BY clause are supported as follows:
Sybase IQ and SQL Anywhere support ROLLUP and CUBE in the GROUP BY clause.
Adaptive Server Enterprise does not currently support ROLLUP and CUBE.
Adaptive Server Enterprise supports projecting nongrouped columns in the SELECT clause. This is known as extended group by semantics and returns a set of values. Sybase IQ supports and SQL Anywhere do not support extended group by semantics. Only SQL Anywhere supports the List() aggregate to return a list of values.
For information about using GROUP BY with OLAP functions, see Chapter 2, “Using OLAP” in the System Administration Guide: Volume 2.
