SELECT NO,NAME,DECODE(GREATEST (AMOUNT,0),0,AMOUNT,0) "DEBIT",DE

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
Suneel Reddy

Question Posted / shailesh

6 Answers
8818 Views
Target, I also Faced
E-Mail Answers

Answer Posted / shailesh

SELECT NO,NAME,DECODE(GREATEST
(AMOUNT,0),0,AMOUNT,0) "DEBIT",DECODE(GREATEST
(AMOUNT,0),0,0,AMOUNT) "CREDIT" FROM ACCOUNT

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we rollback truncate?

1059

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2081

Does group by remove duplicates?

1100

what are all the common sql function? : Sql dba

1113

What is the best sql course?

1031

How do I remove duplicates in two columns?

1163

Is primary key clustered index?

1001

Is primary key always clustered index?

1081

Can we use distinct and group by together?

1116

what is schema? : Sql dba

1124

Can delete statement be rollbacked?

1038

how to escape special characters in sql statements? : Sql dba

1097

how many tables will create when we create table, what are they? : Sql dba

1129

define sql insert statement ? : Sql dba

1086

what are aggregate and scalar functions? : Sql dba

1116