SQL for fun and profit
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.
Check out Turso for SQLite in production: https://tur.so/af.
Follow Aaron:
Twitter: / aarondfrancis
LinkedIn: / aarondfrancis
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.
Check out the article version of this video: https://aaronfrancis.com/2024/finding...
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
Watch video SQL for fun and profit online without registration, duration hours minute second in high quality. This video was added by user Aaron Francis 23 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11,795 once and liked it 893 people.