/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 vote116 views1 answer
Java sql timestamp now
SQL
0 vote121 views3 answers
Condition in count sql
SQL
23 votes109 views6 answers
How to create table in sql
SQL
1 vote108 views1 answer
Reutrn string after character sql
SQL
0 vote119 views1 answer
Object of class mysqli_result could not be converted to string
SQL
1 vote110 views1 answer
Oracle truncate partition
SQL
0 vote171 views1 answer
Radius search with point data in mysql
SQL
1 vote115 views1 answer
Mysql check table exists
SQL
-1 vote115 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote114 views2 answers
Oracle sql for each row
SQL