/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 vote185 views1 answer
Raw query must include primary key
SQL
4 votes172 views1 answer
Data types in sql
SQL
3 votes172 views1 answer
Create a table with an id in mysql
SQL
15 votes173 views5 answers
If null mysql
SQL
28 votes134 views6 answers
Distinct sql
SQL
4 votes162 views3 answers
Sql find second highest salary employee
SQL
0 vote199 views1 answer
Mysql best varchar length size
SQL
0 vote242 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote153 views1 answer
Get only first row mysql
SQL
0 vote183 views1 answer
Sql string contains case sensitive
SQL