select account_code,account_type, sum (amt) from tab where to_char(trx

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

Question Posted / ritika yadav

2 Answers
4080 Views
Maruti Suzuki, I also Faced
E-Mail Answers

Answer Posted / ritika yadav

select account_code,account_type, sum (amt)
from tab
where to_char(trx_date,'DD-MM-YYYY') between '01-04-2014' and '30-04-2014'
group by account_code, account_type
order by account_code, account_type;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is number function in sql?

1018

What is trigger types in sql?

1046

what is rollback? : Sql dba

1181

what is heap table? : Sql dba

1141

How to know the last executed procedure?

1156

Is oracle and sql same?

1078

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117

what is single byte over head in oracle..?

2457

Does truncate require commit?

1034

Why do we use procedures in sql?

1141

What is the usage of the distinct keyword?

1277

Which join is like inner join?

1089

What is a trigger in sql?

1234

What is the usage of distinct keyword?

1116

What is forward declaration in pl sql?

1141