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
Смотрите видео SQL for fun and profit онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Aaron Francis 23 Июль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 11,795 раз и оно понравилось 893 людям.