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
- 6951 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / suresh kumar somayajula
Select No,Name,to_char(Sal,'$9999.99') amount from emp;
| Is This Answer Correct ? | 0 Yes | 12 No |
Post New Answer View All Answers
What is the purpose of the sql select top clause?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is the difference between between and in condition operators?
Explain autonomous transaction.
How do I start sql from command line?
What is trigger in sql? Explain
What are the 3 types of behavioral triggers?
How to add, remove, modify users using sql?
What is a stored procedure in sql with example?
Why are cursors used?
what is the difference between undefined value and null value? : Sql dba
How to sort the rows in sql.
What is the order of sql select?
What is over () in sql?
What is trigger price?
