/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 vote165 views1 answer
Date on SQL
SQL
1 vote162 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote182 views1 answer
Oracle tablespace autoextend
SQL
0 vote160 views1 answer
Sql select min
SQL
0 vote173 views1 answer
Postgresql function ROUND
SQL
0 vote162 views1 answer
Char varchar nvarchar sql
SQL
0 vote163 views1 answer
Mysql show category once count how many products
SQL
0 vote167 views1 answer
Inner joint
SQL
0 vote172 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote186 views1 answer
Sql statement show all emails with dome
SQL