RishOraDev's Oracle Blogs

Oracle Database 23ai allows us to use Column Aliases in GROUP BY and HAVING clauses. It also allows us to use Column-position in GROUP BY clause. Let’s see, how. To demonstrate this enhancement, we will work with the EMP table and the DEPT table. SQL> SELECT * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO________ _________ ____________ _______