Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009

    Unanswered: Group by with decode


    can any body help me in this.

    i have account info table like : custid, transid, transdate, amount,Cr_dr (with credited or debited).
    now i want outstanding balance of the customer with each month. like if credit is ore it has to show -balance and also the no of trans he made within that month like (jan,feb).

    Erlier reply will be appreciated

  2. #2
    Join Date
    Aug 2009
    give table structure .... and 2 sample inserts ...

  3. #3
    Join Date
    Jun 2003
    West Palm Beach, FL

    Thumbs down Lazy boy?

    And you intend to just sit on your lazy boy chair while we do the work for you? What have you coded so far?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts