Nested query using while condition - sql

I think you are looking for a hierarchical query like this:

select * from mytableconnect by prior id = parent_idstart with name = 'Manager';

(A "nested table" is something else entirely.)

CodeHunter