select
(case when
(a-b+c)<=0 then 0
when
(a-b+c)>0 then (a-b+c) end) as sumAbc
from hacchu_tbl这个sql可以正常执行,但是我要求这个sumAbc的和,所以这样写了,但是出错,为什么?
没有这种语法么?select
SUM((case when
(a-b+c)<=0 then 0
when
(a-b+c)>0 then (a-b+c) end) as sumAbc) AS Sums
from hacchu_tbl
group by HAC_HINCD, HAC_LSKCD, HAC_LSOKCD, HAC_KAKU
select
(case when
(a-b+c) <=0 then 0
else
(a-b+c) end) as sumAbc
from hacchu_tbl
then 0
when (a-b+c)>0
then sum(a-b+c)
end as sumAbc
from hacchu_tbl
select
SUM((case when
(a-b+c) <=0 then 0
when
(a-b+c)>0 then (a-b+c) end) ) AS Sums
from hacchu_tbl
group by HAC_HINCD, HAC_LSKCD, HAC_LSOKCD, HAC_KAKU
加了group by 条件,但是提示说不是group by 形式
from hacchu_tbl
where (a - b + c) > 0