Question

sql语句,对刚查询的两个列值 进行计算

select SUM(FEE) ,SUM(RC),SUM(FEE)/SUM(RC),
SUM(case when name=a then FEE else 0 end) as a,
SUM(case when name=a then RC else 0 end) as b,
case when HOS_CANTON=CANTON_CODE_XZ then a/b else 0 end,//?
最上面是直接取出sum和,然后进行了SUM(INHOS_FEE)/SUM(INHOS_RC)做运算,但是下面有条件了,应该怎么做别名为a和b的除法运算呢?我要的是一个sql语句而且后面还有很多类似的运算

Answer 1

这个貌似没有办法吧，你只有把a/b换成上面的公式
SUM(case when name=a then FEE else 0 end)/ SUM(case when name=a then RC else 0 end)

Answer 2

做成一个CTE或者子查询。

select a, b,case when HOS_CANTON=CANTON_CODE_XZ then a/b else 0 end as c
from
(
select
SUM(case when name=a then FEE else 0 end) as a,
SUM(case when name=a then RC else 0 end) as b,
from tablename
) as t