Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH RecursiveDepartments AS (
- SELECT
- ID,
- DepartmentName,
- ParentID
- FROM
- tblDepartment
- WHERE
- DepartmentName = 'Математический факультет'
- UNION ALL
- SELECT
- d.ID,
- d.DepartmentName,
- d.ParentID
- FROM
- tblDepartment d
- INNER JOIN
- RecursiveDepartments rd ON d.ParentID = rd.ID
- )
- SELECT
- DepartmentName
- FROM
- RecursiveDepartments;
Advertisement
Add Comment
Please, Sign In to add comment