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>

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

What is using in sql?

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---

What are sql triggers used for?

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

---

What is meaning of <> in sql?

0 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

What is pl sql collection?

0 Answers  

---

What are the limitations of sql express?

0 Answers  

---

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---