How can i reuse an alias column, in a same select statement? 1

[lgf]

I wish to execute the following SQL statement:

select
round(col1 * 2) result_col1,
(result_col1 - 2) col2
from table_test

The result is: >Invalid column name

I don't want to use an another view or any object else...

I just want to reuse a column alias...

Thanks a lot for your help.... It's very important for me.

Thanks.

 

[Gius]

You can try this way.

select
round(col1 * 2) result_col1,
(round(col1 * 2) -2) col2
from table_test

Hope this help.

 

[rcurva]

Or you can also make use of this, embedded query:

SELECT result_col1,
(result_col1 - 2) col2
FROM ( select round(col1 * 2) result_col1,
from table_test );