Make Condition in Decode Function (Tip)

[mirza_rehan]

Senerio: Table name GLTbl have 2 Column AmtDr and AmtCr
If Sum(AmtDr) > Sum(AmtCr) then
Sum(AmtDr) - Sum(AmtCr);
ElsIf Sum(AmtDr) < Sum(AmtCr)
Sum(AmtCr) - Sum(AmtDr);
Else
0;
End If;

Select Decode( Sign(Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0)), 1, Nvl(Sum(AmtDr),0) - Nvl(Sum(AmtCr),0),-1, Nvl(Sum(AmtCr),0) - Nvl(Sum(AmtDr),0),0) Balnce
From GlTbl;

take care


Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[najm]

Asalam-u-alikum
Rehan bahi It's Najm how are you i am on 20 days Leave now i am back i want to know where we use this type of query or also mention the condition/concept of this query it's very typical



Chears
Najm

Najm

[admin]

Ya better to have some output as well on the basis of sample data.thanks