擅长:python、mysql、java
<blockquote>
<p><em>In other Stack Overflow questions/responses, CROSS APPLY has come up. This is not working for me, since I have 10-20 calculated columns I need to create (all of which reference the other calculated columns).</em></p>
</blockquote>
<p><code>CROSS APPLY</code>可以链接:</p>
<pre><code>SELECT t.*, s1.val1, s2.val2, s3.val3
FROM tab t
CROSS APPLY (SELECT t.val1 * t.val2 AS val3 FROM dual) s1
CROSS APPLY (SELECT s1.val3 * 100 AS val4 FROM dual) s2
CROSS APPLY (SELECT s2.val4 * 1000 AS val5 FROM dual) s3
...
</code></pre>
<p>您只需要确保引用对象的顺序正确。在</p>
<p>相关:</p>
<p><a href="https://stackoverflow.com/questions/19185043/how-to-use-a-calculated-column-to-calculate-another-column-in-the-same-view/52024045#52024045">How to use a calculated column to calculate another column in the same view</a></p>