employee_id manager_id designation
101 NULL CEO
102 101 GM
103 102 MANAGER
104 103 SOFTWARE ENGINEER
105 103 SOFTWARE ENGINEER
In this data structure i want make a hierarchi of superior employee id 104
SELECT employee_id,manager_id,designation FROM manager
CONNECT by prior employee_id = 104
This is the query what am used in this am getting the error like this
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'by'.
help me to solve this....