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
- 7473 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
What is serial sql?
State few characteristics of pl/sql?
What are the sql commands?
What are the types of optimization?
What is difference between sql and oracle?
Is primary key is clustered index?
What is a join?
What is sqlca in powerbuilder?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is plpgsql language?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How to test for null values?
What are synonyms in sql?
What is online transaction processing (oltp)?
how tsql statements can be written and submitted to the database engine? : Transact sql
