SELECT '28800102880011' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880010,2880011)
UNION ALL
SELECT '28800452880005' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880045,2880005)
UNION ALL
SELECT '288001228800142880046' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880012,2880014,2880046)
UNION ALL
SELECT '288004728800482880016,2880006' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880047,2880048,2880016,2880006)
UNION ALL
SELECT '28800342880033' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880034,2880033)
UNION ALL
SELECT '28800092880013' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880009,2880013)
UNION ALL
SELECT '28800322880029' as jgh, sum(ckye) as ckye , sum(dkye) as dkye , sum(blye) as blye, sum(jlr) as jlr from think_daily_report where jgh in (2880032,2880029)
union all
select jgh,ckye,dkye,blye,jlr from think_daily_report where jgh not in (2880010,2880011,2880045,2880005,2880012,2880014,2880046,2880047,2880048,2880016,2880006,2880034,2880033,2880009,2880013,2880032,2880029)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/205047.html
標籤：MySQL
上一篇：ACCESS累計遞增求和