/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 vote181 views1 answer
How to get data between a last week in mysql
SQL
0 vote258 views1 answer
Oracle job session
SQL
1 vote229 views2 answers
Sql now - 1 day
SQL
1 vote184 views1 answer
Copy postgres table from one schema into another
SQL
9 votes212 views1 answer
Alter table column change data type to text mysql
SQL
0 vote221 views1 answer
How to find symmetric pairs in sql
SQL
0 vote260 views1 answer
Oracle plsql sleep
SQL
0 vote202 views1 answer
Check if has alpha characters sql
SQL
0 vote193 views1 answer
Copy Table from SQL to CSV
SQL
0 vote200 views1 answer
Groupby sort sql hive
SQL