✏️ Explanatory Question
Answer with Explanation
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