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
7372 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 the types of index in sql?

1071

What is cascade in sql?

966

Which join condition can be specified using on clause?

957

What view means?

983

What is the difference between cluster and non-cluster index?

1108

what are date and time intervals? : Sql dba

1060

What if we write return in procedure?

1431

What is primary key sql?

1043

How do you add a column to a table?

1056

Name the operator which is used in the query for pattern matching?

958

What is secondary key?

935

What is cartesian join in sql?

1135

how to use regular expression in pattern match conditions? : Sql dba

1036

What is a sql trace file?

1034

How to select all records from the table?

1137