Interested to Buy Any Domain ? << Click Here >> for more details...
Explain SELF JOIN ?
- 3 Answers
- 7451 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 |
How do you set a trace flag in sql server?
What is the difference between having and where clause?
What are the benefits and tasks of object explorer? : sql server management studio
Where views are stored in sql server?
What is filter index?
What is the purpose of the tempdb database?
What is sql injection and why is it a problem? : sql server security
What are the disadvantages of primary key and foreign key in SQL?
What is merge?
What are the advantages of having an index on the sql server?
What are the types of sql server?
What are logical database components? : SQL Server Architecture
-
Oracle (3253) - 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)
