Re: Column alias- Can't do this?

There are two problem in this query:

1. alias cannot be used in where clause
2. I think you have to use HAVING clause for group function

Antonio Pascual wrote in message <7ptk3e$5ku_at_nntpa.cb.lucent.com>...
>SQL> r
> 1 select data, avg(is_number(value)) as col1
> 2 from apatest
> 3 where col1 is not null
> 4* group by dato
>where col1 is not null
> *
>ERROR at line 3:
>ORA-00904: invalid column name
>
>I Can't a column alias in the where clause?
>
>regards,
>
>Antonio.
>
>
Received on Tue Aug 24 1999 - 04:39:21 CDT