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 advantage of index in sql?
What do you mean by stored procedures?
Explain the working of foreign key?
Can we rollback truncate?
What are local and global Indexes and where they are useful.
How many types of triggers are there in pl sql?
How many rows can sqlite handle?
What is the maximum number of rows in sql table?
What is the use of desc in sql?
what is the command line end user interface - mysql? : Sql dba
What is package in pl sql with an examples?
What is trigger price?
what is row? : Sql dba
What are different joins used in sql?
Is t sql a programming language?