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

What are expressions?

1022

What is the difference between join and natural join?

937

Which table is left in join?

986

What is the default isolation level in sql server? : Transact sql

1040

What is multiple partition?

974

how would you enter characters as hex numbers? : Sql dba

995

How do I view stored procedures?

981

Is sql a case sensitive language?

954

Is record in oracle pl sql?

977

What is sql and its types?

1200

How to handle bulk data?

1320

how to concatenate two character strings? : Sql dba

1113

What are the different ddl commands in sql?

1181

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1073

What is difference between sql function and stored procedure?

1017