---
title: "oracle case"
author: "winzenghua"
date: "2009-05-18T10:46:00Z"
tags: []
slug: "oracle-case"
draft: false
lastmod: "2009-05-18T10:46:00Z"
id: 987883
url: "https://java4gis.iteye.com/blog/987883"
---

select wnameb,sum(F\_CopeUserA),sum(F\_CopeUserB),sum(F\_CopeUserC),sum(F\_CopeUserD)  
from  
(  
select (case when wtype in(44,123,43,49) then '任选九场'  
when wtype in(14,11,13) then '胜负十四场'  
when wtype in(154,51,153,42,4,3,135,2,1,151,40,152,41,150,34) then '北京足球单场'  
end ) as wnameb,F\_CopeUserA,F\_CopeUserB,F\_CopeUserc,F\_CopeUserd  
from  
(  
select wtype,wname,  
sum (case when BuyType= 1 then 1 else 0 end) F\_CopeUserA, --统计各购买类型的人数  
sum (case when BuyType= 2 then 1 else 0 end) F\_CopeUserB,  
sum (case when BuyType= 3 then 1 else 0 end) F\_CopeUserc,  
sum (case when BuyType= 4 then 1 else 0 end) F\_CopeUserd  
from test3  
group by wtype,wname  
)  
)  
group by wnameb