/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

1 vote326 views1 answer
Psql search table
SQL
0 vote340 views1 answer
Mysql value ends with
SQL
0 vote298 views1 answer
Change data type in mysql
SQL
19 votes324 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote289 views1 answer
Linux upload database to mysql
SQL
0 vote307 views1 answer
Sql select by content lenght
SQL
0 vote329 views1 answer
How to check event scheduler status mysql
SQL
0 vote282 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
23 votes292 views6 answers
Create table sql
SQL
2 votes367 views1 answer
Capitalize 1st letter in sql server
SQL