我希望的到的结果是(表中记录为):
1,100(no为2时的num),100(no为2时的num),100(no为3时的num)
2, 100(no为2时的num),0 (no为2时的num),100(no为3时的num)
3, 0 (no为2时的num),0 (no为2时的num),300(no为3时的num)现在行了吗????
1,100(no为2时的num),100(no为2时的num),100(no为3时的num)
2, 100(no为2时的num),0 (no为2时的num),100(no为3时的num)
3, 0 (no为2时的num),0 (no为2时的num),300(no为3时的num)现在行了吗????
sum(decode(no,2,num,0)) no2,
sum(decode(no,3,num,0)) no3
from table_name
group by seq