Can we group by two columns in sql?

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

Can there be 2 primary keys in a table?

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,

---

What is pls_integer in pl sql?

0 Answers  

---

---

How do I turn a list into a table?

0 Answers  

---

How do you exit in sql?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

How to run pl sql program in mysql?

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

what are the demerits of sql?

1 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---