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
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 are the different sql languages?
What is posting?
What is online transaction processing (oltp)?
how to use case expression? : Sql dba
How can you know that statistics should be updated?
What is query syntax?
Does inner join return duplicate rows?
Does mysql_real_escape_string prevent sql injection?
What is the use of pl/sql table?
What is the use of & in pl sql?
how many groups of data types? : Sql dba
What are different types of sql?
Can we commit inside a trigger?
What are records give examples?
Does sap use sql?