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

When is the update_statistics command used?

1125

Why trigger is used in sql?

976

What is sql procedures and functions?

1012

how to create a test table in your mysql server? : Sql dba

1013

How do I make sql search faster?

1001

What is the difference between drop and truncate commands?

1062

What is sql injection vulnerability?

948

Is record in pl sql?

979

Does truncate need commit?

948

What is trigger explain it?

1019

which tcp/ip port does sql server run on? : Sql dba

1029

Explain foreign key in sql?

1035

What is blind sql injection?

1079

What is a recursive stored procedure?

1186

What is schema in sql example?

1185