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

How do sql databases work?

947

How can get second highest salary in sql?

912

Explain cursor types?

957

what are the join types in tsql? : Transact sql

983

What is the most restrictive isolation level? : Transact sql

1028

What is autocommit sql?

926

What is a trigger in sql?

1158

What is auto increment in sql?

1063

How can I see all tables in sql?

990

What is the difference between inner join and natural join?

956

What is the use of <> sql?

933

Is inner join same as self join?

1064

what is a database? : Sql dba

1101

What is sql analyzer?

963

What are all types of user defined functions?

1006