Select No No,Name Name,Decode(Amount,Abs(Amount),Amount,0) Credit, Deco

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 / vijay sultampur

5 Answers
7062 Views
Target, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

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

1006

What is the difference between microsoft access and sql?

961

Is sqlite thread safe?

993

What are the types of optimization?

889

What are system versioned tables?

969

Explain the uses of database trigger.

1055

How can you fetch common records from two tables?

1004

What are the different tcl commands in sql?

1106

how to fetch alternate records from a table? : Sql dba

1053

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1007

What is left join in postgresql?

998

Is delete faster than truncate?

960

what is 'mysqlshow'? : Sql dba

975

Explain the the update statement in sql?

990

What is schema in sql?

887