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
- 3483 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
Does view store data in sql?
what happens if you no create privilege in a database? : Sql dba
Is sql port 1433 encrypted?
What is sql partition function?
What is the usage of when clause in trigger?
Does sqlite need a server?
What is difference between pls_integer and integer?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How to select 10 records from a table?
how can you see all indexes defined for a table? : Sql dba
What is localdb mssqllocaldb?
How do you add a column to a table?
Does sql full backup truncate logs?
Write a sql query to get the third highest salary of an employee from employee_table?
Is truncate ddl or dml?
