17,140
社区成员




非常谢谢。长见识了还有,如果没有这个函数,应该怎么样写?谢谢。 select material_id,sum(decode(kind,'enter',material_number,0)-decode(kind,'out',material_number,0)) from test group by material_id
select material_id,sum(decode(kind,'enter',material_number,0)-decode(kind,'out',material_number,0)) from test group by material_id