select no, name, decode (sign(amount),1 , amount , 0) credit, decode (sig

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 / omi naik

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

Answer Posted / omi naik

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

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is record in oracle pl sql?

904

How can use stored procedures in sql?

1083

what is query cache in mysql? : Sql dba

993

What is an exception in PL/SQL? What are the two types of exceptions?

1194

Which is better stored procedure or query?

922

What is crud sql?

925

Can we alter stored procedure?

945

How do I get sql certification?

926

What is the difference between local variables and global variables?

1071

How do I view a sql database?

985

What is exception? What are the types of exceptions?

1035

what is the difference between inner and outer join? Explain with example. : Sql dba

974

How delete a row in sql?

929

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1300

What is difference between ms sql and mysql?

914