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.

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

Normalization and denormalization

3 Answers   Wipro,

---

Explain stored procedure?

0 Answers  

---

When you should use a low fill factor?

0 Answers  

---

What do you mean by subquery?

0 Answers  

---

How to create a simple stored procedure in ms sql server?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,

---

How to edit table in sql server 2017?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

How do I manually uninstall an instance of sql server 2016?

0 Answers  

---