skip to main content
Supported SQL Functionality : Group By Clause

Try DataDirect Drivers Now

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. 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