求一个难的SQL语句
SQL语句：
Select Product_id,Name,(sum(ppvalue +curvalue)) as totalvalue From productpraise_cp_view group by product_id,name order by totalvalue desc
现在要求其中求和的ppvalue和curvalue 是来自表A中的isadauit列的值为1的才相加。视图中的PPVALUE和CURVALUE就是来自表A。
[解决办法]
Select Product_id,Name,(sum(case when isadauit=1 then ppvalue +curvalue else 0 end)) as totalvalue From productpraise_cp_view group by product_id,name order by totalvalue desc
[解决办法]
Select Product_id,
Name,
(sum( case when isadauit = 1 then ppvalue +curvalue else 0 end )) as totalvalue
From productpraise_cp_view
group by product_id,name
order by totalvalue desc
[解决办法]
Select Select Product_id,Name, (select sum(ppvalue +curvalue) from productpraise_cp_view where product_id=a.product_id and Name=a.Name and isadauit=1) as totalvalue From productpraise_cp_view agroup by product_id,name order by totalvalue desc select Product_id,Name, sum(case when isadauit=1 then ppvalue +curvalue else 0 end) as totalvaluefrom productpraise_cp_viewgroup by product_id,name order by totalvalue desc
