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
Answer Posted / ajit nayak
select no, name,
case sign(amt) when 1 then amt else 0 end crd,
case sign(amt) when -1 then amt else 0 end debt
from account;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of index in sql?
Does pdo prevent sql injection?
What is a table?
Is sql port 1433 encrypted?
Is oracle sql free?
What is varchar data type in sql?
What is aggregate function in sql?
Does view store data in sql?
What is the difference between delete and truncate commands?
what is the difference between delete and truncate statement in sql? : Sql dba
What are the types of queries in sql?
what is the difference between a local and a global temporary table? : Sql dba
How is data stored on a disk?
What is mdb stand for?
What is difference between sql and excel?