/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 vote182 views1 answer
Conda install pymysql "windows"
SQL
1 vote183 views1 answer
How to see logical reads in sql server
SQL
5 votes198 views2 answers
Oracle list columns
SQL
0 vote221 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote195 views1 answer
Less than date query sqlachemy
SQL
0 vote190 views1 answer
Sql database connectivity
SQL
0 vote171 views1 answer
Create function syntax sql server
SQL
1 vote206 views2 answers
Create table if not exist
SQL
14 votes228 views1 answer
Excel is not a database
SQL
0 vote196 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL