oracle 23ai group by position

GROUP BY Column Alias or Position in Oracle 23ai

In Oracle 23ai database you can now GROUP BY using an alias or column position. This means you no longer have to write aggregation groups containing certain expressions several times and it will just simplify your SQL query writing. GROUP