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
- 8433 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / shailesh
SELECT NO,NAME,DECODE(GREATEST
(AMOUNT,0),0,AMOUNT,0) "DEBIT",DECODE(GREATEST
(AMOUNT,0),0,0,AMOUNT) "CREDIT" FROM ACCOUNT
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is trigger in sql and its types?
what are the different index configurations a table can have? : Sql dba
What is implicit cursor in pl sql?
How do I run pl sql in sql developer?
Are stored procedures faster than dynamic sql?
explain what is mysql? : Sql dba
what is rdbms? : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Are left and right joins the same?
How can the performance of a trigger be improved?
Does sql require a server?
What are aggregate and scalar functions?
What are different types of tables in sql?
How do you update sql?
What are the differences between in and exists clause?
