![]() ![]() At some point there is an end condition, so it doesn’t call itself indefinitely. A recursive query is basically a query that calls itself. Due to the reflection, it becomes a picture in a picture.Ī recursive query repeatedly run on a subset of the data. ![]() Here you see picture of opposing mirrors. We’ll go deep into recursive CTE’s in a separate post, but for now let me introduce to you recursion using this diagram: Recursion can be a pretty difficult topic to grasp, I really didn’t get it until I took a LISP class way back in 1986, but hopefully I can explain it to you. Recursive CTE’s are common table expressions that reference themselves.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |