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
Suneel Reddy
- 6 Answers
- 8498 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / john bershan
@ mkumar.it
the query which you have posted will work if the amount
value is greater than zero and will not work in the case
when the vale s zero as it will throw divisor is equal to
zero.please check it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why is sql*loader direct path so fast?
What are the topics in pl sql?
how to see the create table statement of an existing table? : Sql dba
What is triggering circuit?
How do I delete a trigger?
What is left join example?
What are types of exception?
Is inner join faster than left join?
What is a mutating table and a constraining table?
What is procedure explain with example?
how is exception handling handled in mysql? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
Why we use triggers in mysql?
What are the query optimization techniques?
How does cross join work?
