9:14 derived table 11:09 SQL standard timeline 11:42 problem with derived table 11:53 the more query I need to add in derived table, the *more they are nested and difficult to read* 12:50 solution - CTE (common table expression) 13:56 example of benifiting from *recursive common table expression* 15:50 new requirement 17:38 solution with SQL 17:52 the 2nd level is also not difficult to get 18:04 what if we need many levels 18:21 SQL: WITH RECURSIVE 19:27 recursive member 20:47 Window functions
9:14 derived table
11:09 SQL standard timeline
11:42 problem with derived table
11:53 the more query I need to add in derived table, the *more they are nested and difficult to read*
12:50 solution - CTE (common table expression)
13:56 example of benifiting from *recursive common table expression*
15:50 new requirement
17:38 solution with SQL
17:52 the 2nd level is also not difficult to get
18:04 what if we need many levels
18:21 SQL: WITH RECURSIVE
19:27 recursive member
20:47 Window functions
Recursive queries just blew my mind.
Cool Dracula cape.
Well, he's called Vlad and he's from Romania, so really nice touch imo.
❤ and true 🎉