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
    Clark2Manager2450-New YorkUnited States77827839314
       Bhatt3Manager3900-BangaloreIndia8013778255
          Goel4Salesman1800300BangaloreIndia8014801300
          Kumar4Salesman1700-BangaloreIndia8015801300
          Khan4Analyst1600-BangaloreIndia8016801300
          Singh4Analyst1500300BangaloreIndia8017801300
          Verma4Analyst1400-BangaloreIndia8018801300
1 - 8