SQL代码如下:SELECT e.userno,e.fullname, COUNT(sp.id) pactct, SUM(sp.tamt) pactamt, COUNT(so.id)ordct, SUM(so.zhtamt) ordamt, COUNT(c.id)custct, COUNT(coct.id)CONCT, COUNT(po.id)porct, SUM(po.zhtamt) poram FROM hr_employee e LEFT JOIN scm_salepact sp ON sp.saler=e.id AND sp.shstate=2 AND sp.ctime >='2014-01-01' AND sp.ctime<='2014-12-31' LEFT JOIN scm_saleorder so ON so.saler=e.id AND so.shstate=2 AND so.ctime >='2014-01-01' AND so.ctime<='2014-12-31' LEFT JOIN crm_customer c ON c.creater=e.id AND c.ctime >='2014-01-01' AND c.ctime<='2014-12-31' LEFT JOIN crm_contactrecord coct ON coct.lxr=e.id AND coct.ptime >='2014-01-01' AND coct.ptime<='2014-12-31' LEFT JOIN scm_salepriceorder po ON po.creater=e.id AND po.shstate=2 AND po.ctime >='2014-01-01' AND po.ctime<='2014-12-31'
而运行的结果却是:
这些统计值都是重复了
求解!!
select id,name,count(distinct id) from tablename
加上count(distinct id)
试试
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。