Group By Clause
The Group By clause is supported, with the following Entry SQL level restrictions:
The COLLATE clause is not supported.
SELECT DISTINCT is not supported.
The grouping column reference cannot be an alias. Both of the following queries fail, because
fc is an alias for the
intcol column:
SELECT intcol AS fc, COUNT (*) FROM p_gtable GROUP BY fc
SELECT f(col) as fc, COUNT (*) FROM table_name GROUP BY fc
