select no, name, decode (sign(amount),1 , amount , 0) credit, decode (sig

Hello All,

Could any well write a query for the following scenario.

Account(table name)

No Name Amount
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.50
4 JKLM 4000.00
5 MNOP 6000.00

O/p Should be in this format

No Name Credit Debit
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.50
4 JKLM 0 -4000.00
5 MNOP 6000.00 o

could any one give appropriate query for this

Thnks in Advance

Question Posted / omi naik

5 Answers
7357 Views
Target, I also Faced
E-Mail Answers

Answer Posted / omi naik

select no, name,
decode (sign(amount),1 , amount , 0) credit,
decode (sign(amount),-1 , amount , 0) debit
from account

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is mariadb a nosql database?

1055

Define tables and fields in a database

1130

How does cross join work in sql?

1015

Which software is used for pl sql programming?

986

What is clause in sql?

1108

Are null values same as that of zero or a blank space?

1026

What is pivot in sql?

911

What is pessimistic concurrency control? : Transact sql

1086

how do you know the version of your mysql server? : Sql dba

1004

What is a relationship and what are they?

1149

What is a sql select statement?

1039

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

What is coalesce sql?

997

What is informix sql?

975

What is a parameter query?

1083