現在一張表里不同的條件查出了兩個SUM，那現在怎么用一個陳述句把這兩個SUM值求和呢
SELECT sum(a.total_csm - a.fc_fy_csm - a.feed_cpc_fy_csm - a.feed_cpm_fy_csm-a.ppzx_jp_hy_csm-a.ppzx_jp_jj_csm-a.ppzx_core_other_csm)/1000 as csm
FROM apps.apps_v_summary_di as a
WHERE a.dt >= '20200101' and a.dt <= '20200523'
and a.cust_id in (select f.id from hn_fj_bn.bmd f)
SELECT sum(a.total_csm - a.fc_fy_csm - a.feed_cpc_fy_csm - a.feed_cpm_fy_csm-a.ppzx_jp_hy_csm-a.ppzx_jp_jj_csm-a.ppzx_core_other_csm)/1000 as csm
FROM apps.apps_v_summary_di as a
WHERE a.dt >= '20200101' and a.dt <= '20200523'
and a.cust_id in (429130296,429210182,429154578)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/284949.html
標籤：基礎類
上一篇：關于開發票