GROUP BY clause

Some databases allow you to specify a column index in the GROUP BY clause:

SELECT a, b, sum(c) FROM table GROUP BY 1,2

This is not possible with all database servers:

Table 1. Database server support of GROUP BY column index
Database Server Type	GROUP BY colindex, ... ?
IBM® Informix®	Yes
Microsoft™ SQL Server	No
Oracle® MySQL / MariadDB	Yes
Oracle Database Server	Yes, since Oracle 23ai See `GROUP_BY_POSITION_ENABLED`
PostgreSQL	Yes
SAP HANA®	No
SQLite	Yes
Dameng®	No

Search for GROUP BY in your SQL statements and use explicit column names.