/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

6 votes160 views4 answers
Mysql get random row
SQL
0 vote157 views1 answer
Excel vba import data to sql server
SQL
0 vote145 views1 answer
Raiserror with nowait
SQL
3 votes136 views3 answers
Into in sql
SQL
0 vote163 views1 answer
This week mysql
SQL
1 vote135 views1 answer
Mysql get latest duplicate rows
SQL
1 vote283 views3 answers
Create table from existing table in sql
SQL
-1 vote151 views2 answers
Import data from excel to sql server automatically
SQL
12 votes153 views10 answers
Google
SQL
3 votes133 views1 answer
APEX elapsed time
SQL