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;

What are the differences between in and exists clause?

0 Answers  

What are literals in sql server?

0 Answers  

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

what is 'mysqlshow'? : Sql dba

0 Answers  

What is the difference between sql and isql*plus?

0 Answers  

How do I tune a sql query?

0 Answers  

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

How do I edit a trigger in sql developer?

0 Answers  

how many ways we can we find the current date using mysql? : Sql dba

0 Answers  

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,