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
    Baker2Manager3300-MontrealCanada700178391429
       Costa3Manager2000200MadridSpain6006700135
          Castillo4Salesman2300-MadridSpain6007600600
          Romero4Analyst3000-MadridSpain6008600600
          Gonzalez4Manager2000200BarcelonaSpain6096600622
1 - 6