在检索查询中定义SQL变量

I have a recursive (using CTE) query to get the top level parent of a certain child/grandchild. And I have a big view that contains the id of the child/grandchild. Here is my recursive query:I have a recursive (using CTE) query to get the