我有一張桌子
我想將蘋果分類如下
我嘗試添加如下代碼，但它不像我預期的那樣
SELECT apple_id, sum(apple_wgt)
,case when apple_colour != 'no colour' then sum(apple_wgt) as 'apple_wgt_no_colour'
,case when apple_colour = 'no colour' then sum(apple_wgt) as 'apple_wgt_colour'
from apples
group by apple_id, apple_wgt
我也嘗試使用此代碼，但出現錯誤
SELECT apple_id, sum(apple_wgt)
,case when apple_colour != 'no colour' then sum(apple_wgt) end as 'apple_wgt_no_colour'
,case when apple_colour = 'no colour' then sum(apple_wgt) end as 'apple_wgt_colour'
from apples
group by apple_id,
case when apple_colour != 'no colour' then sum(apple_wgt) end,
case when apple_colour = 'no colour' then sum(apple_wgt) end
uj5u.com熱心網友回復：
您需要在此處進行條件聚合，這涉及對CASE運算式求和：
SELECT
apple_id,
SUM(apple_wgt) AS apple_wgt,
SUM(CASE WHEN apple_colour != 'no colour'
THEN apple_wgt ELSE 0 END) AS apple_wgt_no_colour
FROM yourTable
GROUP BY
apple_id;
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/355978.html