Categories / recursion
Using UNION vs UNION ALL in Recursive CTEs: When to Make a Difference in Database Performance and Readability.
Understanding Recursive Averages in SQL: An AR(1) Model for Time Series Analysis and Forecasting with SQL Code Examples
BigQuery Recursive Queries: A Deep Dive into Using Recursion to Get All Children of a Node