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 retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

---

What are the two characteristics of a primary key?

0 Answers  

---

What is schema in sql example?

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

What is Histogram?

0 Answers   NIIT,

---

How many sql commands are there?

0 Answers  

---

what are enums used for in mysql? : Sql dba

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

Explain what is a column in a table?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

how are mysql timestamps seen to a user? : Sql dba

0 Answers  

---