/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

1 vote150 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
-1 vote145 views1 answer
Su: Authentication failure mysql
SQL
0 vote137 views1 answer
Mysql query single row
SQL
2 votes139 views1 answer
Mariadb JSON_EXTRACT
SQL
2 votes100 views1 answer
Foreign key example in dbms
SQL
2 votes160 views1 answer
Install postgresql centos 5
SQL
0 vote184 views1 answer
Sql server datetime
SQL
0 vote171 views1 answer
Mysql command line top 10
SQL
0 vote138 views1 answer
SQL loop with cursor
SQL
0 vote142 views1 answer
Change date in pivot table to month in sql server
SQL