/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

2 votes155 views1 answer
Mysql virtual column
SQL
0 vote168 views1 answer
Sql min
SQL
0 vote170 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote151 views1 answer
Show the colums of table sql
SQL
44 votes236 views6 answers
Rename command in sql
SQL
0 vote164 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
1 vote160 views1 answer
Tsql get beginning of year
SQL
0 vote144 views1 answer
Mysql update sequence with order by
SQL
0 vote171 views1 answer
Postgre query date
SQL
25 votes173 views4 answers
Metadata
SQL