oracle笔试题求助

[txh027]

这个要怎么写，

[bw555]

百度 行转列
sum(decode())
pivot

[美到心痛]

select GoodName 物品,
sum(decode(Cls,'进',Qty,0)) 进货数量,
sum(decode(Cls,'出',Qty,0)) 出货数量,
sum(decode(Cls,'进',Qty,'出',-Qty)) 当前库存
from GoodDt1
group by GoodName

[huangdh12]

引用 2 楼 sjcss 的回复:

select GoodName 物品,
sum(decode(Cls,'进',Qty,0)) 进货数量,
sum(decode(Cls,'出',Qty,0)) 出货数量,
sum(decode(Cls,'进',Qty,'出',-Qty)) 当前库存
from GoodDt1
group by GoodName

行转列，考group by 还有decode 的使用。

[lovmayouye]

同意楼上的

[萧萧910130]

同意2楼！！！！！！！