Uploaded July 2024 | Updated September 2026, 1 hour ago
Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com.
Recursive CTEs (common table expressions) are really powerful, and actually useful! In this video, I demonstrate how to use a recursive CTE in SQLite to identify a missing order from an orders table, showcasing a practical solution to a common business problem. This technique is not only powerful for maintaining data integrity but also impressively versatile for various scenarios, such as filling gaps in sequences like dates or numbers.
Get your free SQLite reference guide: highperformancesqlite.com/products/sqlite-reference-guide
Follow Aaron:
Twitter: twitter.com/aarondfrancis
LinkedIn: linkedin.com/in/aarondfrancis
Website: aaronfrancis.com - find articles, podcasts, courses, and more.
Check out the article version of this video: aaronfrancis.com/2024/finding-missing-orders-with-a-recursive-cte-bf59e6de
Chapters:
00:00 Recursive CTE in SQLite
00:31 Orders Table Set-Up
01:55 Find Missing Order using Recursive CTE
05:40 When to Use Recursive CTE
Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com.
Recursive CTEs (common table expressions) are really powerful, and actually useful! In this video, I demonstrate how to use a recursive CTE in SQLite to identify a missing order from an orders table, showcasing a practical solution to a common business problem. This technique is not only powerful for maintaining data integrity but also impressively versatile for various scenarios, such as filling gaps in sequences like dates or numbers.
Get your free SQLite reference guide: highperformancesqlite.com/products/sqlite-reference-guide
Follow Aaron:
Twitter: twitter.com/aarondfrancis
LinkedIn: linkedin.com/in/aarondfrancis
Website: aaronfrancis.com - find articles, podcasts, courses, and more.
Check out the article version of this video: aaronfrancis.com/2024/finding-missing-orders-with-a-recursive-cte-bf59e6de
Chapters:
00:00 Recursive CTE in SQLite
00:31 Orders Table Set-Up
01:55 Find Missing Order using Recursive CTE
05:40 When to Use Recursive CTE
