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
3864 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 are the nonstandard string types? : Sql dba

1085

What are the different types of database management systems?

951

what are the performance and scalability characteristics of mysql? : Sql dba

944

What is a primary key sql?

991

Where is sql database stored?

921

What are the packages in pl sql?

968

What is the difference between row level and statement level trigger?

960

How do I run sql?

1096

Is sql a microsoft product?

897

Why is normalization important?

973

How to use transactions efficiently : transact sql

993

What is latest version of sql?

983

what is a trigger in mysql? Define different types of trigger. : Sql dba

1012

Which command is used to call a stored procedure?

954

What is the best sql course?

933