/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 vote217 views1 answer
Psql datestyle
SQL
0 vote209 views1 answer
Time in sql server
SQL
0 vote206 views1 answer
Opensuse start MySQL
SQL
-1 vote226 views1 answer
Concat two columns in sql server
SQL
2 votes257 views1 answer
Postgresql group by month and year
SQL
0 vote220 views1 answer
Empty table sqlite
SQL
9 votes237 views3 answers
Where clause sql
SQL
0 vote207 views2 answers
Avg() sql
SQL
0 vote208 views1 answer
Truncate a table then insert data
SQL
0 vote262 views3 answers
How to find all role in mysql
SQL