/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 vote108 views1 answer
Postgres jsonb array push new element
SQL
0 vote122 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
6 votes66 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote106 views2 answers
Sql for date greater than
SQL
0 vote117 views1 answer
Mysql workbench not showing schemas
SQL
4 votes135 views5 answers
Get last query in codeigniter 4
SQL
0 vote113 views1 answer
Create table database in psql
SQL
1 vote124 views1 answer
Postgres cast as currency format
SQL
0 vote118 views1 answer
Psql generate id in existing database
SQL
2 votes115 views2 answers
Create empty table from existing table
SQL