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
       Mwangi3Manager1300-NairobiKenya8059756647
          Naeku4Clerk2300-NairobiKenya8060805900
          Sher4Analyst3300-NairobiKenya8061805900
          Kimathi4Analyst4300-NairobiKenya8062805900
          Van Den Berg4Manager1300-Cape TownSouth Africa8063805933
             Knight5Clerk2300-Cape TownSouth Africa8064806300
             Matiou5Analyst3300-Cape TownSouth Africa8065806300
             Nadar5Analyst4300-SandtonSouth Africa8066806300
1 - 10