Interested to Buy Any Domain ? << Click Here >> for more details...
Explain SELF JOIN ?
- 3 Answers
- 7345 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 many types of subqueries are there in sql server?
What is a domain constraint give an example?
What is 2nf in normalization?
What is multilevel indexing?
Explain different isolation levels?
If we delete pack Spec what will be the status of pack Body ?
What is blocking and how would you troubleshoot it?
Explain mixed authentication mode of sql server?
What is a virtual table in sql?
When would you use the stored procedures or functions?
What are different types of collation sensitivity?
How to locate and take substrings with charindex() and substring() functions?
-
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)
