โ† Numerify questions

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.