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.
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:
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 non-grouped 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 clause”. Adaptive Server Anywhere does not support extended group by semantics. Only Adaptive Server Anywhere supports the List() aggregate to return a list of values.
