Loading

Query

Shubham Srivastava

14y1.3k

Hi Friend,

I have a problem in database. There are a table with colums Emp_ID, Emp_name and Manager_ID and i fetch the data Emp_Name who is the is the Manager correspond to Manager_ID.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Shubham,

Table employee

Create table employee (Emp_ID varchar(255),Emp_name varchar(255),Manager_ID varchar(255))

Table Data
Emp_ID   Emp_name Manager_ID
1    Raj      Null
2                Ravi    1
3                Rahul     2

Query

SELECT     e.Emp_ID, e.Emp_name
FROM         employee AS e INNER JOIN
                      employee AS m ON e.Manager_ID = m.Emp_ID

Output

Emp_ID   Emp_name Manager_ID

2                Ravi    1
3                Rahul     2

Thanks