/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 vote419 views1 answer
Split first name and last name in sql
SQL
0 vote334 views1 answer
Call function sql oracle
SQL
2 votes300 views4 answers
Mysql change database character set to utf8mb4
SQL
10 votes368 views4 answers
Primary key in sql
SQL
1 vote395 views1 answer
Create email address from first and last name in sql
SQL
3 votes347 views2 answers
Monthname sql
SQL
0 vote348 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote347 views1 answer
Null column as zero in mysql
SQL
0 vote338 views1 answer
Mysql select last 15 minutes
SQL
0 vote357 views1 answer
Sql query to find duplicate email address
SQL