/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

0 vote412 views1 answer
Mssql find deadlocks
SQL
0 vote339 views1 answer
Pl sql search saurce code
SQL
0 vote353 views1 answer
Oracle sql date winter time
SQL
1 vote350 views1 answer
Spring postgresql reset auto increment to 0
SQL
2 votes340 views1 answer
Sql select min value from multiple columns
SQL
2 votes340 views1 answer
Oracle log files
SQL
1 vote397 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote346 views1 answer
Many rows to 1 string mysql
SQL
0 vote350 views4 answers
Best data type to represent money in mysql
SQL
2 votes353 views2 answers
Run mysql command from bash
SQL