/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 vote129 views2 answers
Mysql multiply
SQL
10 votes115 views4 answers
Primary key in sql
SQL
1 vote128 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote136 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote131 views1 answer
Sql update subtract value
SQL
0 vote129 views1 answer
Difference between db.query and db.execute
SQL
6 votes129 views3 answers
Check if string contains substring sql
SQL
2 votes121 views2 answers
Mysql all columns
SQL
1 vote135 views2 answers
Find nth highest salary of an employee
SQL
2 votes123 views1 answer
Delete all value query
SQL