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.

how to find 6th highest salary

0 Answers   Chetak Logistics,

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

How many types of stored procedures are there in sql server?

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

1 Answers   Logitech, Mphasis,

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

Define full outer join in sql server joins?

0 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---