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
8818 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

define sql insert statement ? : Sql dba

1086

Can we use distinct and group by together?

1116

Is inner join faster than left join?

1265

What is the current version of postgresql?

1144

how to start mysql server? : Sql dba

1249

what is dbms? : Sql dba

1048

Is primary key clustered index?

1001

Can we rollback truncate?

1059

What is the best sql course?

1031

what is schema? : Sql dba

1124

how to escape special characters in sql statements? : Sql dba

1097

what are all the common sql function? : Sql dba

1113

what is sql server agent? : Sql dba

1162

What is the current version of sql?

1082

what is bcp? When does it used? : Sql dba

1040