select no, name, case amount/abs(amount) when 1 then amount else 0 end cre

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 / mkumar.it

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

Answer Posted / mkumar.it

select no, name,
case amount/abs(amount) when 1 then amount else 0 end credit,
case amount/abs(amount) when -1 then amount else 0 end Debit
from account

Is This Answer Correct ?

10 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle and pl sql?

1121

What is the best free sql database?

1057

What is self-join and what is the requirement of self-join?

1152

What is difference sql and mysql?

992

Why select is used in sql?

1023

what is a database transaction? : Sql dba

1189

How do I find sql profiler?

945

Is record in oracle pl sql?

969

Can sql developer connect to db2?

1056

What are user defined functions?

1024

Is there any restriction on the use of union in embedded sql?

1160

What are the different operators available in sql?

1004

What is scalar and vector?

1005

how do you tune the slow running queries in oracle db , explain the methodology

2813

What is an alias command?

1071