Pearlfromsu

less2

Dec 2nd, 2024
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.49 KB | None | 0 0
  1. WITH RecursiveDepartments AS (
  2.     SELECT
  3.         ID,
  4.         DepartmentName,
  5.         ParentID
  6.     FROM
  7.         tblDepartment
  8.     WHERE
  9.         DepartmentName = 'Математический факультет'
  10.    
  11.     UNION ALL
  12.    
  13.     SELECT
  14.         d.ID,
  15.         d.DepartmentName,
  16.         d.ParentID
  17.     FROM
  18.         tblDepartment d
  19.     INNER JOIN
  20.         RecursiveDepartments rd ON d.ParentID = rd.ID
  21. )
  22. SELECT
  23.     DepartmentName
  24. FROM
  25.     RecursiveDepartments;
  26.  
Advertisement
Add Comment
Please, Sign In to add comment