2010-07-14 11:40:42
/ [测试用例设计]
Select sum(nvl(a.amt, 0)) amt1,sum(nvl(b.amt, 0)) amt2,sum(nvl(a.amt, 0)) - sum(nvl(b.amt, 0)) amt3,nvl(curbal, 0) amt4,ORIGINALBAL amt5,curbal amt6,endbal amt7,t.Account,t.ctrlid,t.bdglevel,m.account oriaccountFrom t_glbdgctrl t,t_glrecord a,t_glrecordbdg b,(Select Distinct ctrlid, accountFrom (Select casewhen b.amt > 0 then.
查看(1534)
评论(5)