/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 vote345 views1 answer
Java sql connection
SQL
0 vote287 views1 answer
Count char in java
SQL
1 vote350 views3 answers
How to truncate table with foreign key constraint
SQL
-1 vote274 views1 answer
Mysql how to set update or create
SQL
0 vote357 views1 answer
Adding primery key constraint to a column
SQL
9 votes374 views3 answers
Where clause sql
SQL
1 vote328 views1 answer
Create temporal table in sql
SQL
-1 vote333 views1 answer
Sql set max value in column
SQL
0 vote332 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote331 views1 answer
Sql datediff db2
SQL