/SQL/Recursive query herarchical data sql server

Recursive query herarchical data sql server

WITH cte_org AS (
    SELECT       
        staff_id, 
        first_name,
        manager_id
        
    FROM       
        sales.staffs
    WHERE manager_id IS NULL
    UNION ALL
    SELECT 
        e.staff_id, 
        e.first_name,
        e.manager_id
    FROM 
        sales.staffs e
        INNER JOIN cte_org o 
            ON o.staff_id = e.manager_id
)
SELECT * FROM cte_org;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

1 vote141 views2 answers
Begin transaction in sql
SQL
0 vote128 views2 answers
Mysql regexp match word
SQL
0 vote139 views1 answer
Initcap in mysql
SQL
0 vote136 views1 answer
Can we rollback in sql
SQL
0 vote137 views1 answer
Mysql where in keep order
SQL
0 vote159 views1 answer
Nuget sqllite-net-pcl
SQL
2 votes135 views1 answer
Pandas to sql index
SQL
1 vote136 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote147 views1 answer
Mysql group by derived column
SQL
21 votes166 views6 answers
Update sql
SQL