/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

14 votes305 views3 answers
Trim sql
SQL
3 votes312 views1 answer
Get current month last date in sql server
SQL
0 vote277 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote287 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
8 votes308 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote284 views1 answer
How to install mysql without admin rights
SQL
2 votes306 views1 answer
Mysql sysdate - 1 day
SQL
1 vote348 views4 answers
How to check table in postgresql from terminal
SQL
0 vote301 views1 answer
OFFSET consulta mysql
SQL
0 vote333 views1 answer
Python sqlalchemy connection show server
SQL