/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 vote236 views1 answer
How to install mysql without admin rights
SQL
0 vote238 views1 answer
MySQL import data from large CSV file
SQL
0 vote237 views3 answers
Sql all columns
SQL
0 vote225 views1 answer
How to insert same table data using mysql query
SQL
5 votes240 views1 answer
Oracle create table comment
SQL
0 vote267 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote238 views1 answer
Mysql is odd
SQL
1 vote221 views1 answer
Oracle lowercase
SQL
0 vote231 views1 answer
Mysql pv progres
SQL
22 votes264 views3 answers
How to join three tables in sql using joins
SQL