Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 7281 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
What is bitemporal narrowing?
How can you create an empty table from an existing table?
What is the difference between rollback and rollback to statements?
What is cursor explain with example?
What are the different ways to optimize a sql query?
Does sql between include endpoints?
How to make a copy values from one column to another in sql?
Is sql harder than python?
What is file based approach?
How to run sql statements through the web interface?
what are null values? : Sql dba
what is error ora-03113: end-of-file on communication channel?
How does join work in sql?
How do I pipe the output of one isql to another?
Is full outer join same as cross join?
