Rekursiv CTElar qachon ishlatilishini misol keltira olasizmi?

Rekursiv CTE (Common Table Expressions) ma'lumotlar tuzilmalari bilan ishlash uchun qo'llaniladi, masalan, daraxt yoki graflarni aylanib chiqish uchun.

Misol: tashkilot tuzilmasida barcha bo'ysunuvchilarni olish.

WITH RECURSIVE Subordinates AS (
    SELECT employee_id, manager_id, name
    FROM employees
    WHERE employee_id = 1  -- boshlang'ich rahbar
    UNION ALL
    SELECT e.employee_id, e.manager_id, e.name
    FROM employees e
    INNER JOIN Subordinates s ON e.manager_id = s.employee_id
)
SELECT * FROM Subordinates;

Ushbu so'rov, employee_id = 1 bo'lgan rahbarning barcha bo'ysunuvchilarini rekursiv tarzda yig'adi.