โ† BNY Mellon questions

Hierarchy query

Filed under BNY Mellon

Given an 'employees' table with 'id', 'name', and 'manager_id', write a SQL query to retrieve all employees under a specific manager, including those at all levels of the recursive hierarchy.

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related BNY Mellon questions

Collected from public candidate posts and coding forums. Updated Nov 2026.