oracle ²éѯÓï¾äµÄ±àд °ÝÍи÷λ¡«¡«¡«¡«¡«

ÔÚÒ»¸ö a ±íÖÐÓÐ×ֶΠa1¡¢ a2 ¡¢ a3 ¡¢a4 ¡¢a5, a1ÊDZàºÅ£¨Ö÷¼ü£©¡¢a2ÊÇÃû³Æ¡¢a3ÊÇ״̬ ¡¢a4ÊÇÌáÎÊ¡¢a5»Ø´ð


ÎÊÌ⣺ÔõôÓÃÒ»ÌõsqlÓï¾ä²éѯ³öÀ´ÏÂÃæ±í

  ±àºÅ Ãû³Æ ÌáÎÊ×ÜÊý δ»Ø´ðÌáÎÊ£¨×´Ì¬1£© ÒѻشðÌáÎÊ£¨×´Ì¬2£©
  1 ÕÅÈý 3 2 1
  2 ÕÔËÄ 4 2 2
  3 ÍõÎå 5 5 0
  4 ÀîÁù 6 0 6




Ôڴ˹òл

---

ÐÐÁÐת»»µÄ¾­µäÎÊÌâ
sum(decode())À´×ö
Ö»ÊÇԭʼÊý¾ÝÊÇÔõôÑùµÄ£¿
״̬ÊÇÔõôÑùµÄ

---

¸ù¾Ýa2Ãû³Æ·Ö×éºóͳ¼Æ·Ö״̬´¦Àí

---

ûÓÐÊý¾Ý°¡

---

ÒýÓÃ

ÐÐÁÐת»»µÄ¾­µäÎÊÌâ
sum(decode())À´×ö
Ö»ÊÇԭʼÊý¾ÝÊÇÔõôÑùµÄ£¿
״̬ÊÇÔõôÑùµÄ

ÌùµãÊý¾Ý¿´¿´

---

ÒýÓÃ

select a1,a2,count(1),sum(case when a3=0 then 1 else 0 end),
sum(case when a3=1 then 1 else 0 end)
from tab
group by a1,a2

ÎÊÌâÒѽâ¾ö£¬Ð»Ð»

---

select a1,a2,count(1),sum(case when a3=0 then 1 else 0 end),
sum(case when a3=1 then 1 else 0 end)
from tab
group by a1,a2 ¾­µä