Select No,Name,to_char(Sal,'$9999.99') amount from emp;

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 / suresh kumar somayajula

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

Answer Posted / suresh kumar somayajula

Select No,Name,to_char(Sal,'$9999.99') amount from emp;

Is This Answer Correct ?

0 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is top in tsql? : Transact sql

1117

What is a recursive stored procedure?

1183

what is a composite key ? : Sql dba

1060

What is sql scripting?

1119

What is union?

1169

Describe sql comments?

1039

What is the basic form of sql query?

943

How many disk partitions should I have?

988

Explain polymorphism in pl/sql.

1120

Explain what is a subquery ?

1188

What is the difference between joins?

1039

What is java sql connection?

1057

What is cold data?

960

Is join and inner join the same?

1002

What is dcl in sql?

960