ÇóÒ»sqlÓï¾äµÄд·¨

select p.name,sum(p.cost),p.typyid from  Plan_info p left join dept d on p.planid = d.planid
  group by p.type
ÕâÊÇÎÒдµÄÓï¾ä£¬Ô¸ÒâÊÇÒ»¸ö¼Æ»®±íÁ¬½ÓÒ»¸ö²¿ÃÅ±í£¬ÏÖÐèÒªÏÔʾ¼Æ»®Ãû³Æ²¢sum·ÑÓᣵ¥Í³¼Æ¼Æ»®±íʱûÓÐÎÊÌâ¡£¹ØÁªÉϲ¿Ãűíºó¾Í³öÏÖÁ˺ܶàÖظ´¼Ç¼£¬sumµÄÊý¾Ý¾Í²»×¼ÁË£¬ÇóÕýȷд·¨£¬¸Ðл£¡£¡

---

SQL code:
select p.name,sum(DISTINCT p.cost),p.typyid
from Plan_info p left join dept d on p.planid = d.planid
group by p.type


×îºÃÊÇÏÈͳ¼ÆÔÙ×Ó²éѯ,Ò»¶¨²»»á³ö´í

---

SQL code:
select p.name,sum(DISTINCT ISNULL(p.cost,0)),p.typyid
from Plan_info p left join dept d on p.planid = d.planid
group by p.type

---

select p.name,sum(p.cost),p.typyid from  Plan_info p left join dept d on p.planid = d.planid
  group by p.name,p.typyid

---

SQL code:
select p.name,p.cost,p.typyid from
(
select sum(cost) cost,typyid,planid,name from Plan_info group by typyid,planid,name
)
p left join dept d on p.planid = d.planid

---

ÒýÓÃ

SQL codeselect p.name,sum(DISTINCT p.cost),p.typyidfrom Plan_info pleftjoin dept don p.planid= d.plani