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
- 7628 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
Can you have a foreign key without a primary key?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
what is heap table? : Sql dba
Is it possible for a table to have more than one foreign key?
What is the difference between clustered and non-clustered index in sql?
What is multiple partition?
what are the differences between char and nchar? : Sql dba
How many postgresql users are there, worldwide?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are the three pl sql block types?
what is sub-query? : Transact sql
What is the difference between left outer join and left join?
What is a schema sql?
Write the command to remove all players named sachin from the players table.
What is latest version of sql?
