Employee hierarchy query from boss and designation tables
Filed under Numerify
The question
Given two tables containing boss ID/employee under ID and employee ID/designation respectively, write a SQL query to display the hierarchy for any selected employee based on designation, and explain the key choices.
No write-up yet. Related questions below have one.
Related Numerify questions
Collected from public candidate posts and coding forums. Updated Nov 2026.