/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 vote253 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
2 votes257 views2 answers
Mysql alter column default
SQL
0 vote277 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote247 views2 answers
Postgresql create role
SQL
0 vote249 views1 answer
Date diff sql
SQL
2 votes259 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote259 views1 answer
How to create a new db from dumb file mysql
SQL
1 vote256 views2 answers
Login to mysql
SQL
7 votes253 views2 answers
Add column table pl sql
SQL
0 vote257 views1 answer
Shell script to log mysql cpu usage
SQL