select query

From: shif (ns_0001_at_hotmail.com)
Date: 12/01/04

  • Next message: Vishal Parkar: "Re: select query" 
    Date: Wed, 1 Dec 2004 07:35:07 -0800

    Hi
    I am having a table ,
    acct dramt cr_amt
    101 5
    103 5
    101 10
    how can i make a select stmt which gives the net bal,if sum(dr_amt ) - sum(
    cr_amt) > 0 group by acct,it must come in dr_amt column else in cr_amt.
    in select result. result looks like this.
    acct dramt cramt
    101 5
    103 5
    Is it possible throug a select stmt or insert into select. 

    -- 
Thanks
  • Next message: Vishal Parkar: "Re: select query"