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
- 6875 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
how many tables will create when we create table, what are they? : Sql dba
What is the purpose of using pl/sql?
Why cross join is used?
What are the usages of sql?
Which are the different case manipulation functions in sql?
how to write date and time literals? : Sql dba
Why is nosql good?
how can we repair a mysql table? : Sql dba
What is difference between mysql and postgresql?
What is the difference between delete and truncate commands?
what is the difference between primary key and unique key? : Sql dba
Is sql low level language?
How do I remove all records from a table?
Can we connect to postgresql using sql developer?
What are analytic functions in sql?
