/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 vote135 views1 answer
Mysql check if string contains comma separated
SQL
54 votes192 views6 answers
Sql rename column
SQL
3 votes125 views1 answer
Query less than datetime sql
SQL
1 vote121 views1 answer
Oracle create index if not exists
SQL
1 vote111 views1 answer
Postgres set column equal to another
SQL
0 vote117 views1 answer
Top 3 salary in sql
SQL
4 votes111 views1 answer
Oracle error compilation line
SQL
6 votes114 views2 answers
Mysql get yesterday
SQL
3 votes122 views3 answers
C# sql select
SQL
0 vote125 views1 answer
Get date ISO in psql
SQL