Real life Example of SELF Join

SQL >   SQL Joins >   Self Join  

Long Question

1431


Answer:

Have you ever thought of a need to join a table with itself. Consider tblEmployees table shown below.

Write a query which gives the following result.

Self Join Query:
A MANAGER is also an EMPLOYEE. Both the, EMPLOYEE and MANAGER rows, are present in the same table. Here we are joining


This Particular section is dedicated to Question & Answer only. If you want learn more about SQL. Then you can visit below links to get more depth on this subject.




Join Our telegram group to ask Questions

Click below button to join our groups.