/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

3 votes137 views1 answer
Get all elements sql
SQL
10 votes157 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote156 views1 answer
Ubuntu connect to mssql database
SQL
1 vote135 views1 answer
Postgres convert date to string
SQL
1 vote152 views1 answer
Mysql show long running queries
SQL
3 votes122 views1 answer
Oracle wait
SQL
2 votes121 views1 answer
Sqlplus clear screen
SQL
3 votes157 views3 answers
Sql current year
SQL
1 vote158 views2 answers
Oracle 18c xe ORA-65096
SQL
18 votes137 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL