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.

Is oracle faster than sql server?

0 Answers  

---

What is b tree index?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

mention different types of relationships in the dbms?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

How do I partition a table in sql server?

0 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

What is analysis service repository?

0 Answers  

---

Explain about local stored procedure?

0 Answers  

---