/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 vote194 views1 answer
Mysql group by range
SQL
17 votes199 views6 answers
Sql select distinct
SQL
2 votes215 views1 answer
Metasploit start postgresql
SQL
0 vote198 views1 answer
Sql count matching group by
SQL
0 vote194 views1 answer
Mysql failed to login as root@localhost
SQL
3 votes191 views2 answers
Sql get month name
SQL
0 vote196 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote205 views1 answer
Date datatype in livesql
SQL
3 votes181 views1 answer
Sql select all
SQL
0 vote196 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL