select中有2个 sum,sum(1),sum(2),判断如果sum(1)大于某个值 sum(2)乘一个比例,怎么实现 ,
如果是sum(1)乘一个比例好实现
select case sign(sum(1) - XX)when 1 then sum(1)*0.3 else sum(1) end from YY
如果是sum(1)乘一个比例好实现
select case sign(sum(1) - XX)when 1 then sum(1)*0.3 else sum(1) end from YY
放在子查询中,然后使用case when
(
select id , A = sum(A) , B = sum(B) from tb group by id
) t
select id,sum(a) as a,sum(b) as b from tb
group by id
having sum(a) > sum(b)