The GROUP BY clause

Informix^® allows you to use column numbers in the GROUP BY clause

SELECT ord_date, sum(ord_amount) FROM order GROUP BY 1

IBM^® DB2^® does not support column numbers in the GROUP BY clause.

Solution

Use column names instead:

SELECT ord_date, sum(ord_amount) FROM order GROUP BY ord_date