Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which are the olap features?
Which is the latest version of sql server and when it is released?
Explain what are the authentication modes in sql server?
What is optimistic concurrency?
Is it possible to update the views? If yes, how, if not, why?
How to use "begin ... End" statement structures in ms sql server?
Describe in brief sql server monitoring ways.
How to replace the Query Result 'Null Value' with a text ?
What are the characteristics of modern DBMS?
What is query and its types?
difference between Clustered index and non clustered index ?
How do you migrate data from mssql server to azure?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What will be the maximum number of indexes per table?
what is nonclustered index
