Hello,
Is it possible to reuse a previously calculated column in a following
column, like:
SELECT
foo.val1 AS col1,
long_calculation(foo.val1) AS col2,
COL2 * 0.75 AS col3
FROM foo;
instead of writing:
SELECT
foo.val1 AS col1,
long_calculation(foo.val1) AS col2,
long_calculation(foo.val1) *
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
Subject: Re: [SQL] 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 co