Answer / manoj pandey

SELF JOIN is like joining a table with itself, to get a recursive series of data within the table. Like in Employee table to get Manager details you need to join Manager ID with Employee ID in the same table, like:

SELECT
E.EmployeeID,
E.EmployeeName,
E.ManagerID,
M.EmployeeName as ManagerName
FROM Employee E
LEFT JOIN Employee M
ON M.EmployeeID = E.ManagerID

~Manoj(SQLwithManoj.wordpress.com)

Answer / dinesh rathod

Self join is just like any other join, except that two instances of the same table will be joined in the query

Answer / sandhya

JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TABLE WITH DIFFERENT ALIYAS'S.

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

How do I open a .db file?

0 Answers  

---

explain different types of constraints? : Sql server database administration

0 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

Explain how to use linked server?

0 Answers  

---

Explain different backup plans?

0 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---

What is the process of normalising?

0 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

What is the bookmark lookup and rid lookup?

0 Answers  

---