SQL needed to find parent department in department tree for any given department name

Summary:

SQL needed to find parent department in department tree for any given department name

Content (required):

Hi All,

Please share SQL to find parent department in department tree for any given department name

Version (include the version you are using, if applicable):

21d

Code Snippet (add any code snippets that support your topic, if applicable):