/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 vote272 views1 answer
Codigo crear tablas sql server
SQL
2 votes298 views2 answers
Create empty table from existing table
SQL
13 votes249 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote289 views1 answer
Oracle show grants on table
SQL
3 votes295 views1 answer
Create a table with an id in mysql
SQL
4 votes264 views3 answers
Mysql varchar length
SQL
0 vote282 views1 answer
Delete first row in sql
SQL
0 vote266 views1 answer
Sql server remove 0 from left
SQL
0 vote275 views1 answer
Sql date d'aujourd'hui
SQL
0 vote270 views1 answer
Mysql check datetime equals date
SQL