select no, name, case sign(amt) when 1 then amt else 0 end crd, case sign

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

Question Posted / ajit nayak

5 Answers
7061 Views
Target, I also Faced
E-Mail Answers

Answer Posted / ajit nayak

select no, name,
case sign(amt) when 1 then amt else 0 end crd,
case sign(amt) when -1 then amt else 0 end debt
from account;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are all the different normalization?

979

What do you mean by “trigger” in sql?

1019

What are the benefits of stored procedures?

999

What is cross join sql?

868

Is sql procedural language?

921

What is the difference between left join and right join?

889

how to create a new view in mysql? : Sql dba

895

What is a dynamic query?

973

What are schema-level triggers?

1047

Is left join inner or outer by default?

975

What are the uses of sysdate and user keywords?

1053

What is ttitle and btitle?

1006

Does truncate table reset auto increment?

941

How do I run pl sql in sql developer?

1063

What is pessimistic concurrency control? : Transact sql

1025