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>

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What is the maximum number of rows in sql table?

0 Answers  

---

In a distributed database system, can we execute two queries simultaneously?

0 Answers  

---

How do I view a sql trace file?

0 Answers  

---

Why do we need a foreign key?

0 Answers  

---

How do I view a sql database?

0 Answers  

---

How sql query is executed?

0 Answers  

---

What is data definition language?

0 Answers  

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

Does normalization improve performance?

0 Answers  

---

What is nvarchar max in sql?

0 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---