/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 vote225 views4 answers
Postgres between dates
SQL
0 vote199 views1 answer
Mysql range of dates overlap
SQL
1 vote178 views1 answer
Regular expression in sql server
SQL
0 vote188 views1 answer
Drop all triggers oracle
SQL
0 vote186 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote179 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote228 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote192 views1 answer
Import sql in postgresql
SQL
2 votes186 views1 answer
Set boolean flasksql
SQL
0 vote219 views1 answer
Mysql relationships between tables
SQL