擅长:python、mysql、java
<p>这是标准的SQL功能,定义它是有充分理由的:数据库不需要以任何顺序计算<code>select</code>表达式。所以,没有“之前”的别名。在</p>
<p>SUB CTE是正常的查询:</p>
<pre><code>SELECT t.*,
(value_calculated_2 * 1000) AS value_calculated_3
FROM (SELECT t.*,
(value_calculated * 100) AS value_calculated_2
FROM (SELECT date, value1, value2,
(value2 * value1) AS value_calculated
FROM . . .
) t
) t
</code></pre>