Interested to Buy Any Domain ? << Click Here >> for more details...
Explain SELF JOIN ?
- 3 Answers
- 7324 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sandhya
JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TABLE WITH DIFFERENT ALIYAS'S.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is master database? : SQL Server Architecture
How do you troubleshoot SQL Server if its running very slow?
What is key set driven?
What is a natural primary key?
What is a transaction and why is it important?
Explain unique key in sql server?
How can I create a report based on a query? : sql server management studio
Is sql server difficult to learn?
Where are stored procedures in sql server?
What is a non-clustered index?
How can we Use Linked Server? Uses of Linked server
What are the recovery models in sql server 2000?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
