/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 vote278 views1 answer
How to rename a database in tsql
SQL
17 votes220 views4 answers
Set mysql Password
SQL
0 vote222 views1 answer
Oracle current session details
SQL
8 votes227 views5 answers
Alter table add column with default value
SQL
0 vote225 views1 answer
Mysql procedure between two tables
SQL
10 votes244 views4 answers
Primary key in sql
SQL
0 vote281 views1 answer
Osm2pgsql mac
SQL
0 vote184 views1 answer
Oracle function select into
SQL
1 vote234 views1 answer
Postgresql how to show table names
SQL
0 vote227 views1 answer
Value of sold product using having and group by in sql
SQL