How long have you been programing?? I didn't even know tat we could use conditional statements inside queries. Well thank you very much for your time and this lesson God bless.
Iam a beginer so all i did is just joined the two tables and selected all the colums necessary.I was Stuck there. I didnt know what to do next .
Could u please explain how you got that?
I could not upload .sql so i renmed to txt.
This is thr DB.
transaction_db.txt
I have never done any calculations with sql query, so I have no idea how to do this so please help.
well i have two tables acc_tbl and ledger_tbl ( screenshots ) i need to find the the difference between total debit and total credit of that particular ledger debit (Dr) and credit(Cr) everything in screenshot.
All i know was to join the table and select all thr columns available.
Watson gives Sherlock an array A of length N. Then he asks him to determine if there exists an element in the array such that the sum of the elements on its left is equal to the sum of the elements on its right. If there are no elements to the left/right, then the sum is considered to be zero.Formally, find an i, such that, A1+A2.....Ai-1 = Ai+1+Ai+2......AN.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.