select sno,name,decode(sign(amount),1,0,amount)debit,decode (sign(amount),

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 / saravana sundar

6 Answers
8757 Views
Target, I also Faced
E-Mail Answers

Answer Posted / saravana sundar

select sno,name,decode(sign(amount),1,0,amount)debit,decode
(sign(amount),-1,0,amount)credit from account
/

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which join is like inner join?

1089

Is sql a backend language?

1146

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1019

What does joining a thread mean?

1078

Explain the commit statement.

1215

What are tables and fields?

1088

Is a secondary key the same as a foreign key?

1120

List and explain the different types of join clauses supported in ansi-standard sql?

1409

Is a table valued function object?

1076

How many sql statements are used? Define them.

1081

What is Difference Between Unique and Primary Key Constraints?

1155

Can you sum a count in sql?

1061

What is output spooling in sql*plus?

1092

what is blob? : Sql dba

1222

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1633