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
18050 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

What is your daily office routine?

2316

what is meant by urlencode and urldocode? : Sql dba

1242

what is column? : Sql dba

1053

What are the syntax and use of the coalesce function?

1277

What is varchar used for?

1139

What are different types of sql?

1266

What is difference between procedure and trigger?

1022

What is sql in java?

1134

What is the max nvarchar size?

1031

what are date and time data types in mysql? : Sql dba

1025

What sql does db2 use?

1029

what are ddl statements in mysql? : Sql dba

1269

Is sqlite free?

1024

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

1176

how is exception handling handled in mysql? : Sql dba

1132