Wrong forum, we answer questions about the SQL Developer tool here. Better to try SQL & PL/SQL
What you are looking for, however, is an Hierarchical Query...
I will post it in the correct forum.. anyways thanks for the reply.. the link you shared has the query to display all the managers in the hierarchy.
but i am looking for only 2nd most.