Answer / khaleek

There are only three type of joins
1) Equi Join
2) Non Equi Join
3) Cartesian Product or Cross Join.

Further Equi Join and Non Equi join can be divided into
following categories.
1) Inner Join
2) Outer Join
3) Self Join

Again Outer can be divide into following categories.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join

For detail please see at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>

What is the usage of nvl function?

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

What are the different sql commands?

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,

---

Explain what is an index?

0 Answers  

---

---

What is cursor and why it is required?

0 Answers  

---

What is restrict in sql?

0 Answers  

---

What is execution plan in sql?

0 Answers  

---

How can we optimize a sql query?

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

explain the delete statements in sql

0 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---