Recursive SQL - Simplify Your Queries Using Recursion

Recursive SQL - Simplify Your Queries Using Recursion

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.

Follow us on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:


ETL Project? Contact me today!

Check out some of my earlier videos on Data Engineering:

recursive sql, sql recursion, sql recursive, recursive sql example, sql recursion example, recursion in sql, sql generate series with recursion, sql server recursion, oracle recursion, db2 recursion, sean mackenzie data analytics