How to use Recursive SQL - A Simple Example
05-December-2020
In this episode, learn how to use recursive SQL to simplify your programming. Recursive queries allow a
query to query itself until a result set has been established. This can remove the need for loops or
iterative processes that can needlessly complicate your SQL. You can describe a problem with a single
statement that depends on solutions to smaller instances of the same problem. Recursion is a great method
to add to your SQL toolkit!
In our simple examples, we’ll calculate a list of years in a CTE, so that we can use that series in other
queries.
ETL Project? Contact me today!