As new features within Oracle Database 23c, we can use aliases names and/or position number within the clause GROUP BY.
Group by: Aliases names
![](https://wadhahdaouehi.tn/wp-content/uploads/2023/04/Screenshot-from-2023-04-17-11-45-05.png)
Group by : Position Number
Before using position number within group by clause, we need to enable this feature within the session Level.
![](https://wadhahdaouehi.tn/wp-content/uploads/2023/04/Screenshot-from-2023-04-17-13-18-10.png)
Enjoy theses features with 23c