2 ms·
No questions/examples featuring recursive CTE's? They tend to come up in anything involving queries over trees or graphs. They're also a relatively new feature
by zozbot234 7y ago
No questions/examples featuring recursive CTE's? They tend to come up in anything involving queries over trees or graphs. They're also a relatively new feature where having some examples to show how they work may be quite helpful.
- magicalhippo 7y agoTook me some time to wrap my head around writing a recursive query. Also had to study the docs a while to get "merge into" to work right, for doing combined insert/update.
- hotsauceror 7y agoOne of the first tasks I give associate DBAs is writing a recursive CTE to get a blocking chain. It’s an interesting and useful exercise.