Column Alias In Group By / Having

[Sridharan]

Hello All,

Is it possible to use the column alias given in the select clause in Group By / Having clause. When I try to give that it is giving an error. But have worked on that in other RDBMS like Teradata. Is it somewhat possible to achieve???

Example:
--------
select
col1 as col1alias
from
table1
group by
col1alias

Thanks
Sridharan

 

[sunpatil]

It is not possible in oracle.
It's good feature which is also supported by sql server.

regards

sunil

 

[Sridharan]

Thanks Patil.