About

Click an employee name to show that employees reports, peers, and management. This demonstration highlights the SQL CONNECT BY syntax.

Employee Name
Level
Job
Salary
Commission
City
Country
Empno
Mgr
Directs
Total Reports
King1President5000-New YorkUnited States7839-488
    Jones2Manager2975-DallasUnited States75667839536
       Fujita3Manager3300-TokyoJapan90477566616
          Cook4Manager3300-MelbourneAustralia80479047610
             Anders5Manager3950-Sao PauloBrazil8042804744
                Kako6Analyst800-Sao PauloBrazil8043804200
                Mandes6Analyst1100-Sao PauloBrazil8044804200
                Ramos6Analyst2300100Sao PauloBrazil8045804200
                Silva6Analyst2900-Sao PauloBrazil8046804200
             Baber5Analyst1300-MelbourneAustralia8048804700
             Ali5Analyst1300300MelbourneAustralia8049804700
             Burke5Analyst1300-MelbourneAustralia8050804700
             Dale5Analyst1300200MelbourneAustralia8051804700
             Hemmings5Clerk1300-MelbourneAustralia8054804700
1 - 14