/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 vote152 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote148 views1 answer
Sql get number of days between two dates
SQL
1 vote173 views1 answer
Varchar plsql
SQL
10 votes160 views2 answers
Mysql remove only_full_group_by permanently
SQL
-1 vote138 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote158 views1 answer
Hex string sql becomes int64
SQL
1 vote193 views1 answer
Postgresql if 0 then 1
SQL
1 vote151 views1 answer
Set mysql mode global query
SQL
0 vote183 views1 answer
Mysql error codeigniter
SQL
8 votes176 views1 answer
My sql version
SQL