/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 vote341 views1 answer
Sql server query all database objects
SQL
0 vote279 views1 answer
SQL isnumeric DB2
SQL
0 vote273 views1 answer
Get time component of datetime sql
SQL
1 vote284 views2 answers
Change table name phpmyadmin
SQL
1 vote337 views1 answer
Import sql file from laravel
SQL
0 vote298 views1 answer
Get date from timestamp in mysql
SQL
0 vote305 views1 answer
SQL query to verify the size of the table
SQL
3 votes304 views2 answers
How to delete git repo locally
SQL
0 vote280 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote297 views1 answer
Pgsql sum switch case
SQL