/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

3 votes189 views1 answer
Oracle apex call duration
SQL
0 vote185 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote178 views1 answer
Mysql get character set
SQL
0 vote191 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
-1 vote176 views1 answer
How to use update trigger in sql
SQL
2 votes178 views1 answer
Ssh mysql port forwarding
SQL
6 votes183 views1 answer
Phpmyadmin password root
SQL
20 votes204 views6 answers
Creating a table in sql
SQL
2 votes228 views1 answer
Postgresql transaction
SQL
1 vote186 views1 answer
Oracle explain plan
SQL