/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 vote333 views1 answer
Pl/ sql change currency
SQL
0 vote353 views1 answer
SQL check if record exist
SQL
-2 votes345 views2 answers
Union all in sql
SQL
0 vote324 views1 answer
Using GROUP BY in MySQL Join Table
SQL
58 votes564 views4 answers
Mysql drop column
SQL
3 votes331 views1 answer
Oracle show trigger code
SQL
0 vote327 views1 answer
Count characters of string mysql
SQL
1 vote328 views1 answer
Get last week data in mysql
SQL
5 votes341 views1 answer
Invalid column name sql
SQL
0 vote317 views1 answer
Low level operator in dbms
SQL