如果type的个数固定的话,或者由数量范围的话可以做到
select value_date ,sum(decode(typeid,1,value,0)) 'X',sum(decode(typeid,2,value,0)) 'Y',
sum(decode(typeid,3,value,0)) 'Z',sum(decode(typeid,4,value,0)) 'P'
from a group by (value_date);
select value_date ,sum(decode(typeid,1,value,0)) 'X',sum(decode(typeid,2,value,0)) 'Y',
sum(decode(typeid,3,value,0)) 'Z',sum(decode(typeid,4,value,0)) 'P'
from a group by (value_date);
oracle中就没有吗?
如果这一天没有值的话,就应该是0你的查询语句只会列出发生过value的日期