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
       Fujita3Manager3300-TokyoJapan90477566616
          Cook4Manager3300-MelbourneAustralia80479047610
          Hamasaki4Analyst1300-TokyoJapan9048904700
          Kaneko4Analyst1300-TokyoJapan9049904700
          Matano4Analyst1300-TokyoJapan9050904700
          Kondo4Analyst1300-TokyoJapan9051904700
          Nagai4Clerk1300300TokyoJapan9054904700
1 - 9