/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

2 votes177 views2 answers
Get all columns from table sql
SQL
0 vote227 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote193 views1 answer
How to export only procedures mysql
SQL
15 votes209 views4 answers
Pl sql
SQL
1 vote208 views1 answer
Sql select row with max date
SQL
-2 votes252 views1 answer
Trunc in sql
SQL
2 votes212 views1 answer
SQL column name Postgre
SQL
4 votes200 views2 answers
Oracle unlock user
SQL
2 votes187 views1 answer
Drop table purge
SQL
27 votes332 views3 answers
Mysql delete row
SQL