/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 vote140 views1 answer
Uuid sqlalcomany
SQL
11 votes150 views2 answers
Having clause in sql
SQL
0 vote165 views1 answer
Sqlite3 not commit
SQL
1 vote178 views1 answer
Epoch time converter in snowflake
SQL
5 votes143 views4 answers
Select random rows sql
SQL
0 vote139 views1 answer
Sql select lowest value row
SQL
0 vote149 views1 answer
Mysql trim characters
SQL
0 vote150 views1 answer
Amount of entries in a table psql
SQL
0 vote144 views1 answer
Différence entre deux dates sql oracle
SQL
1 vote145 views1 answer
Oracle list datafiles in tablespace
SQL