/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

19 votes221 views6 answers
Create table sqlite
SQL
6 votes196 views1 answer
Oracle trigger after logon on schema
SQL
5 votes251 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote185 views1 answer
How to know if table in rigt or left in sql
SQL
3 votes191 views5 answers
Mysql get last inserted id
SQL
1 vote186 views1 answer
User privileges postgresql information_schema
SQL
0 vote224 views1 answer
Mssql find deadlocks
SQL
6 votes196 views2 answers
Mysql first day of month
SQL
4 votes327 views1 answer
What are the data types
SQL
5 votes231 views2 answers
Oracle show procedures
SQL