@ mkumar.it the query which you have posted will work if the amount va

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 / john bershan

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

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different parts of a package?

1100

Can we write ddl statements in functions?

1095

What is the use of prepared statement?

996

what is sql? : Sql dba

1003

What is sap sql anywhere?

1050

What is group function in sql?

1002

What are procedures used for?

969

Define implicit and explicit cursors.

1126

State some properties of relational databases?

1037

How do you explain an index number?

1080

What is sql and db2?

979

i have some prob lem to tell me about my self in interview first round ...

2151

How do I copy a table in sql?

966

What is duration in sql profiler trace?

1064

what is data integrity? : Sql dba

1020