/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 vote331 views1 answer
Get table column names sql ssms
SQL
1 vote306 views1 answer
Index a database column sql
SQL
1 vote279 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
7 votes340 views5 answers
Sql remove spaces
SQL
8 votes309 views1 answer
Alter tablespace add datafile
SQL
2 votes265 views1 answer
Sql float to int
SQL
5 votes339 views3 answers
MySql get fields of table
SQL
0 vote348 views1 answer
How do I insert a blob in SQL?
SQL
0 vote334 views1 answer
Sql check if column exists
SQL
2 votes342 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL