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
- 6901 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 a column in a table?
how to create a test table in your mysql server? : Sql dba
Is sql a oracle?
How can I tell if sql is running?
What steps server process has to take to execute an update statement?
What is difference between sql and excel?
What are the possible values that can be stored in a boolean data field?
What is autocommit sql?
What is bitemporal narrowing?
What are instead of triggers?
What is the difference between count 1 and count (*) in a sql query?
Determine if oracle date is on a weekend?
how many ways to get the current time? : Sql dba
How to load data with sql*loader?
How do I count duplicates in sql?
