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

6 Answers   Target,

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

What is a left inner join?

0 Answers  

---

What is orm in sql?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

When is the explicit cursor used ?

0 Answers  

---

How do I run a sql query?

0 Answers  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

What is sql not null constraint?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

What are the packages in pl sql?

0 Answers  

---

What is TABLE SPACE?

4 Answers   ABB, TCS,

---