¶àÌõ¼þÇóºÍSqlÓï¾ä

±í¸ñ½á¹¹ account_id, account_name, sellingprice, factory_id  ÀýÈçÊý¾ÝÈçÏ£º
account_id account_name sellingprice factory_id
001 stephe 200 aa
001 stephe 100 bb
002 adrian 200 aa
002 adrian 300 bb
002 adrian 100 cc
003 nweton 250 aa
003 nweton 300 cc

ÏÖÔÚÏëͳ¼Æ½á¹ûÈçÏ£¬account_id, account_name,sum(sellingprice_factory_aa),sum(sellingprice_factory_bb),sum(sellingprice_factory_cc)
Çë¸ßÊÖ°ïæָµãÏÂÈçºÎдsql´úÂ룬лл¡£

---

SQL code:
select account_id, account_name,
sum(case factory_id when 'aa' then sellingprice end) as sellingprice_factory_aa,
sum(case factory_id when 'bb' then sellingprice end) as sellingprice_factory_bb,
sum(case factory_id when 'cc' then sellingprice end) as sellingprice_factory_cc
from ±í¸ñ
group by account_id, account_name

---

SQL code:
SELECT account_id ,account_name ,
[aa]=sum(case factory_id when 'aa' then sellingprice else 0 end),
[bb]=sum(case factory_id when 'bb' then sellingprice else 0 end),
[cc]=sum(case factory_id when 'bb' then sellingprice else 0 end)
from TableName
GROUP BY account_id,account_name

---

¸üÕý£ºSQL code

---

Code highlighting produced by Actipro CodeH