oracleÁÐתÐÐÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚÒ»¸ö±íÖÐÓÐÁ½ÁÐÊý¾Ý
shuliang area
1 025
2 0510
3 0511
4 0512
5 0513
ÒªÇóÊÇ°Ñarea×Ö¶ÎÖеÄֵת»»³É³ÇÊÐÃû³Æ£¬±ÈÈç025ÊÇÄϾ©£¬0510ÊÇÎÞÎý£¬0511ÊÇÕò½­£¬0512ÊÇËÕÖÝ£¬0512ÊÇÄÏͨ
ÏÔʾ³É
ÄϾ© ÎÞÎý Õò½­ ËÕÖÝ ÄÏͨ
1 2 3 4 5

ÇëÎÊsqlÔõôд°¡

---

SQL code:

select sum(case when area = '025' then shuliang else 0 end) as ÄϾ©
,sum(case when area = '0510' then shuliang else 0 end) as ÎÞÎý
,sum(case when area = '0511' then shuliang else 0 end) as Õò½­
,sum(case when area = '0512' then shuliang else 0 end) as ËÕÖÝ
,sum(case when area = '0513' then shuliang else 0 end) as ÄÏͨ
from ±íÃû;

---

select 
case when area='025' then shuliang end ÄϾ©,
case when area='0510' then shuliang end ÎÞÎý,
case when area='0511' then shuliang end Õò½­,
case when area='0512' then shuliang end ËÕÖÝ,
case when area='0513' then shuliang end ÄÏͨ
from ±í;

---

select sum(decode(area, '025', 1, 0)) as ÄϾ©,
  sum(decode(area, '0510', 1, 0)) as ÎÞÎý,
  sum(decode(area, '0511', 1, 0)) as Õò½­,
  sum(decode(area, '0512', 1, 0)) as ËÕÖÝ,
  sum(decode(area, '0513', 1, 0)) as ÄÏͨ
  from t
 group by area

---