/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 votes381 views1 answer
Locate sql server
SQL
1 vote377 views1 answer
Load mysql dumb
SQL
2 votes369 views1 answer
Query any digits record
SQL
0 vote310 views1 answer
Mitigation of sql injection
SQL
0 vote377 views1 answer
Command line mysql xampp
SQL
0 vote485 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
50 votes438 views6 answers
Sql duplicate rows
SQL
0 vote358 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote321 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote405 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL