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
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 schema? : Sql dba
what are all the common sql function? : Sql dba
Can we use distinct and group by together?
Does group by remove duplicates?
what is sql server agent? : Sql dba
what is bcp? When does it used? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are aggregate and scalar functions? : Sql dba
Is primary key clustered index?
Can we rollback truncate?
What is your daily office routine?
Is primary key always clustered index?
how to use regular expression in pattern match conditions? : Sql dba
What is the current version of sql?
Can delete statement be rollbacked?