oracle--同一张表分组统计

select get_hrmsubname(f.subid) subname, 
				sum(case when f.status=1 then 1 else 0 end) status1, 
				sum(case when f.status=2 then 1 else 0 end) status2, 
				sum(case when f.status=3 then 1 else 0 end) status3, 
				sum(case when f.status=5 then 1 else 0 end) status5, 
				sum(case when f.status=4 then 1 else 0 end) status4, 
				sum(case when f.status=6 then 1 else 0 end) status6, 
				sum(case when f.status=7 then 1 else 0 end) status7, 
				sum(case when f.status=9 then 1 else 0 end) status9, 
				sum(case when f.status<>8 then 1 else 0 end) hj  
				from fna_pos_base f where f.status<>8 
				group by f.subid order by hj desc;

通过subid分组，统计各种status的合计

select fpb.id,fpb.asset_name, fpb.company, fpb.pos_machinenum,fpb.pos_merchantnum,
decode(fpb.status,1,'未领用',2,'城市领用',3,'个人领用',4,'调拨中',5,'领用中',6,'归还中',7,'报废中',9,'修改中') status
 from fna_pos_base fpb where fpb.id=862 

nvl(wb.isread,0) isread