SELECT SUM(decode(txn_typ,'D',1)) "Total Debit Count",

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.

Question Posted / deepak mohanty

3 Answers
17904 Views
iNautix, Oracle, I also Faced
E-Mail Answers

Answer Posted / deepak mohanty

SELECT SUM(decode(txn_typ,'D',1)) "Total Debit
Count",SUM(decode(txn_typ,'C',1)) "Total Credit Count",
SUM(decode(txn_typ,'D',txn_amt)) "Total Debit
Amount",SUM(decode(txn_typ,'C',txn_amt)) "Total Credit Amount"
from txn_tab

Is This Answer Correct ?

13 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I order columns in sql?

1014

What is scalar and vector?

1008

Write the alter statement to enable all the triggers on the t.students table.

1128

What is sql partition?

1114

what are the different tables present in mysql? : Sql dba

986

what is a database? : Sql dba

1176

What is pessimistic concurrency control? : Transact sql

1094

What is composite primary key in sql?

1001

What is the difference between joins?

1047

what is denormalization. : Sql dba

1120

What are all the ddl commands?

1186

How do I find sql profiler?

947

What does (*) mean in sql?

955

What is a heap in sql?

1076

How do I trace sql profiler?

991