Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^4: SQL Database Table to Perl Script

by Generoso (Vicar)
on Oct 05, 2012 at 14:17 UTC ( #997484=note: print w/ replies, xml ) Need Help??


in reply to Re^3: SQL Database Table to Perl Script
in thread SQL Database Table to Perl Script

Maybe this SQL will help.

SELECT AccNum, max(date), Type, sum(Amount) FROM transaction GROUP BY + AccNum, Type union SELECT AccNum, max(date),'Balance', sum(if (type='Debit',-1*Amount,Amo +unt)) FROM transaction GROUP BY AccNum; SELECT * FROM transaction t where chequeno is not null or ddno is not +null;

And this has little to do with perl this is an datbase question


Comment on Re^4: SQL Database Table to Perl Script
Download Code
Re^5: SQL Database Table to Perl Script
by prithviraj (Novice) on Oct 05, 2012 at 17:23 UTC
    Sir.For the question below, I want to solve it with a single SQL query. I tried all possibilities but nothing is working. Please help: Query data from transaction table and calculate total amount debited by cheque, dd and by cash for each account.

      1) Query data from transaction table and calculate the total balance in each account

      Select columns from your table, group by "accnum". When "type" = 'credit', then add "amount"; when "type" = 'debit', subtract "amount". And then display the result as a column in your resultset.

      2) Query data from transaction table

      SELECT columns FROM transaction table

      and calculate total amount

      sum(...)

      debited by cheque,

      chequeno IS NOT NULL

      dd

      ddno IS NOT NULL

      and by cash

      chequeno IS NULL AND ddno IS NULL

      for each account.

      GROUP BY accnum

      For the rest, why not look here? And there.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://997484]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (17)
As of 2014-09-19 18:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (144 votes), past polls