/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 vote330 views2 answers
Foreign key set 0
SQL
0 vote324 views1 answer
Mysql select random rows large table
SQL
7 votes313 views5 answers
Show details of table postgres
SQL
0 vote300 views1 answer
Query archive mode
SQL
0 vote343 views1 answer
Mysql average from two table
SQL
5 votes302 views1 answer
Oracle get foreign keys on table
SQL
0 vote327 views1 answer
Oracle session statistics
SQL
-1 vote303 views3 answers
Error mysql shutdown unexpectedly
SQL
13 votes501 views4 answers
Sql joining 3 tables
SQL
0 vote298 views1 answer
Cast as decimal postgresql
SQL