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
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
Can a foreign key be a duplicate?
How does stored procedure reduce network traffic?
What is integrity in sql?
Should I use mbr or gpt?
What is sql injection owasp?
What are different types of tables in sql?
What is the function that is used to transfer a pl/sql table log to a database table?
What is difference between pl and sql?
What is dcl in sql?
What is union and union all keyword in sql?
How do you delete duplicates in sql query using rowid?
What will you get by the cursor attribute sql%found?
Write the command to remove all players named sachin from the players table.
Can we create clustered index without primary key?
What is union and union all keyword in sql and what are their differences?