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
- 8431 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ehtesham malik
Select no,name, 0 Debit, amount Credit
from temp
where amount >0
union
Select no,name, amount Debit, 0 Credit
from temp
where amount < 0
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why we use join in sql?
What is sql select statement?
What are transaction and its controls?
Can triggers stop a dml statement from executing on a table?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
How do I add a primary key to a table?
What can you do with pl sql?
Does inner join remove duplicates?
How to test for null values?
how to extract a unit value from a date and time? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Why primary key is required?
How many unique keys can a table have?
What is a recursive join sql?
What is cascade in sql?
