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
    Jones2Manager2975-DallasUnited States75667839536
       Scott3Analyst3001-DallasUnited States7788756611
       Fork3Analyst3000-BostonUnited States7902756611
       Zhao3Manager3300-BeijingChina8019756666
       Mwangi3Manager1300-NairobiKenya8059756647
       Fujita3Manager3300-TokyoJapan90477566616
    Blake2Manager2851-ChicagoUnited States7698783955
    Clark2Manager2450-New YorkUnited States77827839314
1 - 10