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
7632 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 is the difference between a query and a report?

1055

What does count (*) do in sql?

1050

explain the options of myisamchk to improve the performance of a table. : Sql dba

1072

what are set operators in sql? : Sql dba

1108

How do you optimize a query?

1060

Is join and inner join the same?

1044

how to concatenate two character strings? : Sql dba

1161

what is text? : Sql dba

1120

Is nosql faster than sql?

1073

How many sql commands are there?

1158

How do you use join?

995

What is the use of function "module procedure" in pl/sql?

1236

What does joining a thread mean?

1077

Why are cursors used?

1176

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1116