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
- 6949 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / saravana sundar
select sno,name,decode(sign(amount),1,0,amount)debit,decode
(sign(amount),-1,0,amount)credit from account
/
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Is record in pl sql?
What is an alias command?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is the full form of sql?
What is the use of triggers?
what is the difference between a web-garden and a web-farm? : Sql dba
What is raid? How does it help storage of databases?
what is the syntax used for partition in tsql? : Transact sql
What are its different types of dbms?
What are the types of sql commands?
What's the procedure?
what is 'trigger' in sql? : Sql dba
Is like operator in sql case sensitive?
Does sql support programming?
What is dynamic sql in pl sql?
