table name :Tab
fields name
1.trx_no (pk)
2.trx_date
3.account code (7 char)
4.account type (1 char)
5.amt
Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit .
write a query to display the account code wise total debit and credit bal for the month of april 2004.
write a query to display account code wise new amt credit for the april 2004
- 2 Answers
- 3484 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
Answer Posted / jayashree
SELECT SUM(DECODE(ACC_CODE, 'C', AMT)) Total_credit_bal,
SUM(DECODE(ACC_CODE, 'D', AMT)) Total_debit_bal
from tab
where to_char(trx_date,'DD-MON-YYYY') between
'01-apr-2014' and '30-apr-2014';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data manipulation language?
What's the procedure?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is set serveroutput on in pl sql?
What is scalar function in sql?
What are the advantages of pl sql?
What packages(if any) has oracle provided for use by developers?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is trigger and how to use it in sql?
What is native sql query?
Is sql database free?
Can you join views in sql?
How does index help in query performance?
What is the difference between subquery and correlated query?
how can we know the number of days between two given dates using mysql? : Sql dba
