/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

5 votes108 views2 answers
Sql constraint check value in list
SQL
0 vote115 views1 answer
How to install Firebird
SQL
1 vote128 views3 answers
Postgresql get difference between two dates
SQL
0 vote116 views1 answer
Mssql dockere
SQL
1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
5 votes115 views1 answer
Mysql count newlines in field
SQL
1 vote108 views1 answer
Mysql date diff in seconds
SQL
12 votes107 views2 answers
Delete all entries postgres
SQL
0 vote116 views4 answers
Open mysql port bitnami tomact
SQL
1 vote104 views1 answer
Table information in sql server
SQL