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

Is like operator in sql case sensitive?

1077

what is recursive stored procedure? : Sql dba

1028

What is difference between inner join and cross join?

1019

How is indexing done in search engines?

1023

Define tables and fields in a database

1181

How do you write a complex sql query?

1142

Can you selectively load only those records that you need? : aql loader

1095

What is the difference between instead of trigger and after trigger?

1070

What is a dynamic query?

1073

Do we need to rebuild index after truncate?

1099

What is sharding in sql?

1041

what is try_catch block in procedure

1811

What are the types of variables use in pl sql?

1093

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

What are transaction and its controls?

1091