原sql SELECT coalesce(SUM(telecom_count), 0) AS telecom_count, coalesce(SUM(telecom_money), 0) AS telecom_money, coalesce(SUM(mobile_count), 0) AS mobile_count, coalesce(SUM(mobile_money), 0) AS mobile_money, coalesce(SUM(unicom_count), 0) AS unicom_count, coalesce(SUM(unicom_money), 0) AS unicom_money, coalesce(SUM(fixandphs_count), 0) AS fixandphs_count, coalesce(SUM(fixandphs_money), 0) AS fixandphs_money, coalesce(SUM(recharge_num), 0) AS recharge_num, coalesce(SUM(recharge_money), 0) AS recharge_money FROM (SELECT a.agent_id, coalesce(SUM(a.telecom_count), 0) AS telecom_count, coalesce(SUM(a.telecom_money), 0) AS telecom_money, coalesce(SUM(a.mobile_count), 0) AS mobile_count, coalesce(SUM(a.mobile_money), 0) AS mobile_money, coalesce(SUM(a.unicom_count), 0) AS unicom_count, coalesce(SUM(a.unicom_money), 0) AS unicom_money, coalesce(SUM(a.fixandphs_count), 0) AS fixandphs_count, coalesce(SUM(a.fixandphs_money), 0) AS fixandphs_money, coalesce(SUM(a.recharge_num), 0) AS recharge_num, coalesce(SUM(a.recharge_money), 0) AS recharge_money FROM tb_agent_charge_count a LEFT JOIN tb_agent b ON a.agent_id = b.id WHERE a.agent_id != -10010 AND a.create_date >= to_date('2014-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND a.create_date < to_date('2014-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') GROUP BY a.agent_id) 改后 SELECT coalesce(SUM(telecom_count), 0) AS telecom_count, coalesce(SUM(telecom_money), 0) AS telecom_money, coalesce(SUM(mobile_count), 0) AS mobile_count, coalesce(SUM(mobile_money), 0) AS mobile_money, coalesce(SUM(unicom_count), 0) AS unicom_count, coalesce(SUM(unicom_money), 0) AS unicom_money, coalesce(SUM(fixandphs_count), 0) AS fixandphs_count, coalesce(SUM(fixandphs_money), 0) AS fixandphs_money, coalesce(SUM(recharge_num), 0) AS recharge_num, coalesce(SUM(recharge_money), 0) AS recharge_money FROM tb_agent_charge_count a WHERE a.agent_id != -10010 AND a.create_date >= to_date('2014-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND a.create_date < to_date('2014-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
脑残的sql
原创diter 博主文章分类:sql Tuning ©著作权
©著作权归作者所有:来自51CTO博客作者diter的原创作品,谢绝转载,否则将追究法律责任
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
解读:以RTC为基,AI为脑的“超拟人”AI实时互动解决方案
10分钟构建企业专属「云上智能体」
云计算 视频云 音视频 AI实时互动 AI智能体 -
对脑残的看法
对脑残体的看法 脑残
【】‘’】、