mysql一条sql查出多个条件不同的sum或count
select sum(pzgwjscd) as allJsgm,sbjh.nd as nd, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3301) and ptgw.zt != 0 and sbjh.nd=2017 ) as hzJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3303) and ptgw.zt != 0 and sbjh.nd=2017) as wzJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3304) and ptgw.zt != 0 and sbjh.nd=2017 ) as jxJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3305) and ptgw.zt != 0 and sbjh.nd=2017) as huzJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3306) and ptgw.zt != 0 and sbjh.nd=2017 ) as sxJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3307) and ptgw.zt != 0 and sbjh.nd=2017 ) as jhJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3308) and ptgw.zt != 0 and sbjh.nd=2017 ) as qzJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3309) and ptgw.zt != 0 and sbjh.nd=2017 ) as zsJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3310) and ptgw.zt != 0 and sbjh.nd=2017 ) as tzJsgm, ( select sum(pzgwjscd) from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where substring(ptgw.xzqh,1,4) LIKE CONCAT (3311) and ptgw.zt != 0 and sbjh.nd=2017 ) as lsJsgm from fm_jh_ws_ptgw ptgw left join fm_sb_jh sbjh on ptgw.sbid = sbjh.id where 1=1 and ptgw.zt != 0 and sbjh.nd=2017
数据库表
查询结果：
