SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / Data manipulation |
Informix® allows you to use column numbers in the GROUP BY clause
SELECT ord_date, sum(ord_amount) FROM order GROUP BY 1
Oracle does not support column numbers in the GROUP BY clause.
Use column names instead:
SELECT ord_date, sum(ord_amount) FROM order GROUP BY ord_date