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
       Zhao3Manager3300-BeijingChina8019756666
          Bao4Salesman1600-BeijingChina8020801900
          Cai4Analyst1700-BeijingChina8021801900
          Chan4Analyst1800400BeijingChina8022801900
          Chu4Analyst1900-BeijingChina8023801900
          Feng4Analyst2000100BeijingChina8024801900
          Gao4Analyst2300-BeijingChina8025801900
1 - 9