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

Question Posted / mkumar.it

5 Answers
7293 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 ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different types of database management systems?

983

explain mysql aggregate functions. : Sql dba

974

Is sql port 1433 encrypted?

1013

Explain the working of foreign key?

1050

What is trigger explain with example?

1018

Can we call procedure in select statement?

1041

What is nested table in pl sql?

1053

What is sql integrity?

1138

What is the use of desc in sql?

963

What is the difference between pl and sql?

1079

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

1038

Describe different types of general function used in sql?

1020

What are types of exception?

906

Explain isolation levels. : Transact sql

1050

What is row_number () in sql?

968