Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (E_id, Name, Mg_id) AS
SELECT 1, 'Neel', 2    FROM DUAL UNION ALL
SELECT 2, 'Abhi', 3    FROM DUAL UNION ALL
SELECT 3, 'Neha', NULL FROM DUAL;
3 rows affected

SELECT CONNECT_BY_ROOT name AS name,
       PRIOR name AS mgr_name1,
       name AS mgr_name2
FROM   table_name 
WHERE  LEVEL = 3
START WITH e_id = 1
CONNECT BY PRIOR mg_id = e_id


NAME
MGR_NAME1
MGR_NAME2


Neel
Abhi
Neha


SELECT CONNECT_BY_ROOT name AS name,
       CASE LEVEL
       WHEN 2
       THEN name
       WHEN 3
       THEN PRIOR name
       END AS mgr_name1,
       CASE LEVEL
       WHEN 3
       THEN name
       END AS mgr_name2
FROM   table_name 
WHERE  LEVEL = 3
OR     (LEVEL < 3 AND CONNECT_BY_ISLEAF = 1)
START WITH e_id = 1
CONNECT BY PRIOR mg_id = e_id


NAME
MGR_NAME1
MGR_NAME2


Neel
Abhi
Neha


SELECT CONNECT_BY_ROOT name AS name,
       CASE LEVEL
       WHEN 2
       THEN name
       WHEN 3
       THEN PRIOR name
       END AS mgr_name1,
       CASE LEVEL
       WHEN 3
       THEN name
       END AS mgr_name2
FROM   table_name 
WHERE  LEVEL = 3
OR     (LEVEL < 3 AND CONNECT_BY_ISLEAF = 1)
--START WITH e_id = 1
CONNECT BY PRIOR mg_id = e_id


NAME
MGR_NAME1
MGR_NAME2


Neel
Abhi
Neha

Abhi
Neha
null

Neha
null
null


SELECT t1.name,
       t2.name AS mgr_name1,
       t3.name AS mgr_name2
FROM   table_name t1
       LEFT OUTER JOIN table_name t2
       ON t1.mg_id = t2.e_id
       LEFT OUTER JOIN table_name t3
       ON t2.mg_id = t3.e_id


NAME
MGR_NAME1
MGR_NAME2


Neel
Abhi
Neha

Abhi
Neha
null

Neha
null
null