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 can you check the level of fragmentation on a table?

0 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

What are the advantages of the mirroring?

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

What do you mean by table and field in sql?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---

What is abstracting periodical?

0 Answers  

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

How to download and install sql server 2005 books online?

0 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---