/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 vote276 views1 answer
Postgres reorder columns
SQL
0 vote226 views1 answer
Mysql collation for all languages
SQL
0 vote292 views1 answer
Shortcut run sql pgadmin
SQL
1 vote271 views1 answer
Postgresql last element of array
SQL
4 votes305 views6 answers
List all tables in postgres
SQL
5 votes292 views5 answers
Sqlite install python
SQL
0 vote351 views1 answer
Stop and start mysql
SQL
7 votes279 views1 answer
Sql server convert string to date
SQL
0 vote311 views1 answer
Joomla execute raw sql
SQL
0 vote304 views1 answer
How to connect to xampp sql server on windows cmd
SQL