GROUP BY ALL support differs between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ.
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:
SAP 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. SAP 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.