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,

---

Difference between truncate, delete and drop commands?

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

What is the difference between rename and alias?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

What is a stored procedure ?

9 Answers  

---

What is cte?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

---