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
- 5 Answers
- 7634 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / srinu
Hi Suneel,
SELECT * FROM ACCOUNT;
NO NAME AMOUNT
----- ----- ----------
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.00
4 JKLM -4000.00
5 MNOP 5000.00
SELECT NO,NAME,DECODE(SIGN(AMOUNT),1,TO_CHAR(AMOUNT,'9999.99'),-1,0) CREDIT,
DECODE(SIGN(AMOUNT),-1,TO_CHAR(AMOUNT,'9999.99'),1,0) DEBIT FROM ACCOUNT
/
NO NAME CREDIT DEBIT
------ ----- -------- --------
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.00 0
4 JKLM 0 -4000.00
5 MNOP 5000.00 0
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is a record in a database ? : Sql dba
how to include comments in sql statements? : Sql dba
What is the most important ddl statements in sql are?
What is recursive stored procedure?
What are the types of subqueries?
How many sql statements are used?
How does index help in query performance?
What are the different types of joins in sql?
What is scalar function?
What is sqlexception in java?
Can we use join in subquery?
How many disk partitions should I have?
what is the difference between char and varchar data types? : Sql dba
What is function and procedure?
Which one is faster ienumerable or iqueryable?
