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.
Adaptive Server Anywhere does not support the GROUP BY ALL Transact-SQL extension.
Sybase IQ supports the GROUP BY ALL Transact-SQL extension on a single table only, not in a view.
ROLLUP and CUBE in the GROUP BY clause are supported as follows:
Sybase IQ and Adaptive Server 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 extended group by semantics with some exceptions. For details, see “GROUP BY”. Adaptive Server Anywhere does not support extended group by semantics. Only Adaptive Server Anywhere supports the List() aggregate to return a list of values.
For information about using GROUP BY with OLAP functions, see Chapter 4, “Using OLAP” in the Sybase IQ Performance and Tuning Guide
