/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 vote315 views1 answer
What is metadata in sql
SQL
3 votes246 views4 answers
Show columns from table
SQL
0 vote223 views1 answer
Sql new line output
SQL
0 vote214 views1 answer
Ms sql print more than 1 variable
SQL
4 votes254 views1 answer
Select nls_date_format
SQL
0 vote262 views1 answer
Turn on foreign keys check mysql
SQL
0 vote284 views1 answer
Sql select column name like from multiple tables
SQL
0 vote256 views2 answers
Mysql select date from datetime
SQL
-1 vote268 views2 answers
Postgresql get last 10 records
SQL
-1 vote245 views2 answers
On delete set default sql server
SQL