Monday 16th of September 2019 10:22:51 PM
Our Services
Select Theme
Back
; with  CTE as 
        (
        select  emp_id
        ,       reports_to
        ,       emp_name
        ,       1 as level
        from    Emp
        where   emp_name = 'Sumanta'
        union all
        select  child.emp_id
        ,       child.reports_to
        ,       child.emp_name
        ,       level + 1
        from    Emp child
        join    CTE parent
        on      child.reports_to = parent.emp_id
        )
select  *
from    CTE
 
     
     
Home | About Us | Products | Services |  Templates | Demo | Contact Us | Careers | Feedback | SiteMap
2005-2014 Logical Technologies. All Rights Reserved.