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

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
Suneel Reddy

Question Posted / ehtesham malik

6 Answers
8493 Views
Target, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between instead of trigger and after trigger?

1011

What is pl sql block in dbms?

1006

can a stored procedure call itself or recursive stored procedure? : Sql dba

1031

what is unique key constraint? : Sql dba

1036

What is nvarchar max in sql?

1019

What is user in sql?

1025

What are data types in pl sql?

1144

how to create a new view in mysql? : Sql dba

938

What is graph sql?

995

Can you sum a count in sql?

1013

How to look at the current sql*plus system settings?

1150

Differentiate between % rowtype and type record.

1305

What does subquery mean in sql?

1056

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

1021

What are all the ddl commands?

1184