Re: Reuse previously calculated column in sql query?

On Wed, 2004-10-20 at 08:50, Philippe Lang wrote:
> Hello,
> 
> Is it possible to reuse a previously calculated column in a following
> column, like:

SELECT col1    , col2    , col2 * 0.75 AS col3 FROM (SELECT foo.val1 AS col1            , long_calculation(foo.val1) AS
col2        FROM foo) AS tab;