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