Answer / mkumar.it

select no, name,
case amount/abs(amount) when 1 then amount else 0 end credit,
case amount/abs(amount) when -1 then amount else 0 end Debit
from account

Answer / saravana sundar

select sno,name,decode(sign(amount),1,0,amount)debit,decode
(sign(amount),-1,0,amount)credit from account
/

Answer / ehtesham malik

Select no,name, 0 Debit, amount Credit
from temp
where amount >0
union
Select no,name, amount Debit, 0 Credit
from temp
where amount < 0

Answer / shailesh

SELECT NO,NAME,DECODE(GREATEST
(AMOUNT,0),0,AMOUNT,0) "DEBIT",DECODE(GREATEST
(AMOUNT,0),0,0,AMOUNT) "CREDIT" FROM ACCOUNT

Answer / john bershan

@ mkumar.it

the query which you have posted will work if the amount
value is greater than zero and will not work in the case
when the vale s zero as it will throw divisor is equal to
zero.please check it.

Answer / suresh kumar somayajula

Select No,Name,to_char(Sal,'$9999.99') amount from emp;

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

What is write ahead logging in sql server?

0 Answers  

In testing where do we use sql language and how it helps in testing?

2 Answers  

What is the difference between a query and a report?

0 Answers  

What is the use of partition by in sql?

0 Answers  

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

What is a merge query?

1 Answers  

how to get a list of all tables in a database? : Sql dba

0 Answers  

Name three sql operations that perform a sort.

0 Answers  

What is relationship? How many types of relationship are there?

0 Answers  

How can check sql version from command line?

0 Answers