/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 vote175 views1 answer
Renombrar tabla mysql
SQL
1 vote211 views1 answer
Sql random sampling per group
SQL
0 vote185 views1 answer
Mssql disable foreign key constraint
SQL
0 vote182 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote192 views1 answer
Get last three characters in mysql column
SQL
0 vote167 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote227 views1 answer
Find and replace query in wordpress\
SQL
0 vote174 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote185 views1 answer
Default column value in sql same as another column laravel
SQL
-1 vote168 views1 answer
MYSQL stored procedure select from
SQL