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
       Fouche3Manager1900-ParisFrance8011700155
          Giraud4Clerk1500-LyonFrance4009801100
          Garot4Analyst1600-StrasbourgFrance4010801100
          Agnes4Clerk1700-StrasbourgFrance4011801100
          Ventris4Analyst1800-ParisFrance4012801100
          Fouix4Analyst1000-LyonFrance8012801100
1 - 8