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

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.
  • Comment on Re^5: SQL Database Table to Perl Script

Replies are listed 'Best First'.
Re^6: SQL Database Table to Perl Script
by Anonymous Monk on Oct 05, 2012 at 20:13 UTC

    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.

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom