Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Re^4: SQL Database Table to Perl Script

by prithviraj (Novice)
on Oct 05, 2012 at 09:53 UTC ( #997423=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

Now can you give me the solution for this question please: Query data from transaction table and calculate total amount debited by cheque, dd and by cash for each account.
  • Comment on Re^4: SQL Database Table to Perl Script

Replies are listed 'Best First'.
Re^5: SQL Database Table to Perl Script
by marto (Bishop) on Oct 05, 2012 at 10:05 UTC

    This is a basic SQL question, not a Perl question. I suggest you take the time to learn basic SQL, and for that matter Perl and HTML (note you have <br> tags after <td> tags). You've been given advice already which mentions what SQL functions to read up on, I won't repeat that. I suspect you've been given this task as a learning exercise (be it in an educational establishment, or on the job training/learning), and would suggest you treat it as such.

Re^5: SQL Database Table to Perl Script
by aaron_baugher (Curate) on Oct 05, 2012 at 11:40 UTC
    Now can you give me the solution for this question please:

    If you're hungry and just want a fish to eat, I'll sell you one. If you want to learn to catch your own fish, that's a different situation.

    For your first question, you say you're already successfully getting the credit and debit values, so it looks to me like you'd get the account balance by subtracting one from the other. On the second question, it sounds like you want to group the results by whether the item has a CheckNo value, a DDNo value, or neither. It might be possible to do that with a single fancy SQL statement, but I'd probably just break my statement up into three, adding a WHERE clause to each, like these:

    WHERE CheckNo is not null WHERE DDNo is not null WHERE CheckNo is null AND DDNo is null

    That way your first statement gets the check values, your second gets the DD values, and your third gets the cash values. I assumed that those fields are null when they aren't filled in. If they default to empty strings, you'll need to adjust accordingly. Hope that helps.

    Aaron B.
    Available for small or large Perl jobs; see my home node.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://997423]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2017-02-22 11:07 GMT
Find Nodes?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?

    Results (326 votes). Check out past polls.