Display the total debit counts, total credit counts, sum of
total debits, sum of total credits from an employee's
transaction table (a single table) containing the following
columns.
Transaction_number
Transaction_amount
Transaction_date
Transaction_type --> tells if the amount is a credit or a
debit.
As the query alone is important, the table is left with
specifying just the field's name. Pls help me with this
query.
- 3 Answers
- 16883 Views
- iNautix, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ajit
Also u can use count function to calculate total debit & credit cout.
and u can use this sql stmt
select tran_type, Count(tran_type) total,
(select sum(tran_amt)
from tran
where tran_type = 'D') sumofde,
(select sum(tran_amt)
from tran
where tran_type = 'C') sumofce
from tran
group by tran_type;
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
What is data types in sql?
How is a PL/SQL code compiled?
How to connect a sql*plus session to an oracle server?
what is blob? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What do you mean by rowid?
What is a schema? How is it useful in sql servers?
How do I create a sql database?
what are string data types? : Sql dba
what are the security recommendations while using mysql? : Sql dba
what is the difference between union and union all? : Sql dba
What does partition by mean in sql?
Is stored procedure faster than query?
what is a foreign key ? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
