1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / suneelreddy

Answers were Sorted based on User's Feedback



Hello All, Could any well write a query for the following scenario. Account(table name) No ..

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

Is This Answer Correct ?    4 Yes 0 No

Hello All, Could any well write a query for the following scenario. Account(table name) No ..

Answer / omi naik

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

Is This Answer Correct ?    5 Yes 1 No

Hello All, Could any well write a query for the following scenario. Account(table name) No ..

Answer / srinu

Hi Suneel,


SELECT * FROM ACCOUNT;

NO NAME AMOUNT
----- ----- ----------
1 ABCD 2000.00
2 DEFG -2000.00
3 GHIJ 3000.00
4 JKLM -4000.00
5 MNOP 5000.00

SELECT NO,NAME,DECODE(SIGN(AMOUNT),1,TO_CHAR(AMOUNT,'9999.99'),-1,0) CREDIT,
DECODE(SIGN(AMOUNT),-1,TO_CHAR(AMOUNT,'9999.99'),1,0) DEBIT FROM ACCOUNT
/

NO NAME CREDIT DEBIT
------ ----- -------- --------
1 ABCD 2000.00 0
2 DEFG 0 -2000.00
3 GHIJ 3000.00 0
4 JKLM 0 -4000.00
5 MNOP 5000.00 0

Is This Answer Correct ?    1 Yes 0 No

Hello All, Could any well write a query for the following scenario. Account(table name) No ..

Answer / 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

Hello All, Could any well write a query for the following scenario. Account(table name) No ..

Answer / vijay sultampur

Select No No,Name Name,Decode(Amount,Abs(Amount),Amount,0)
Credit, Decode(Amount,Abs(Amount),0,Amount) Debit
From Account;

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How much does sqlite cost?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

What is primary key and unique key?

0 Answers  

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

0 Answers  

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,




How to find string or key value using pl/sql code?

2 Answers   Ramco,

What are the different types of dbms?

0 Answers  

What operators deal with null?

0 Answers  

what are the type of locks ? : Sql dba

0 Answers  

Which data type doesn't allow null data type?

6 Answers   TCS,

How to handle bulk data?

0 Answers  

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories