如何将表达式中的结果列重用于另一个结果列
例子:SELECT (SELECT SUM(...) FROM ...) as turnover,(SELECT SUM(...) FROM ...) as cost,turnover - cost as profit确定这是无效的(至少在Postgres有效)但是如何在不重写的情况下在查询中达到同样的效果呢?
解决方案:
像这样:
SELECT turnover,cost,turnover - cost as profitfrom ( (SELECT SUM(...) FROM ...) as turnover,(SELECT SUM(...) FROM ...) as cost ) as partial_sums
页:
[1]