Hi I have one table called cllquestion. in that i have got question which have parent question.
I cna create the hirearcy using CTE like child questions for a parent question. But i want it backwards like i have child question and i want all ancestor question for it.
Could you pelase give me the code that how i can do this.