Hierarchical SQL Queries: Databases for Developers #16

Fantastic video!! it's 8pm here at my office and I'm dancing because this function has helped me a lot.

Oh.. to take care of divorces, re marriages, children from multiple marriages.. and… shocker.. marriages of cousins (at a broad 4th/5th level).. i had to patch up the data model.. !!

"But, of course, in real life everyone has two parents" In 2022 is not so obvious...

Where can I find the sql queries shown in this video?

thank you for this video

just made reading a while wall of text easier but is there any tutorial or exercise i can practise this with?

<3

too much illustration is distracting and annoying.

Great Video!, Helped me understand the concept .

Snowden is now teaching SQL seems FUN

The background music needs to be changed.

So amazing ! Keep producing videos, please. Thank you !

Thumbed down, misleading title. This is "Oracle Databases" for developers

i love the effort

Ok...why in the recursive with do you have a "yf." there is no alias refereing to a yf table...

Is the hierachical query faster than the nested set model?

What about Binary.

WHAT CAN I DO WITH MYSQL WHEN I WANT TO RESOLVE THE PROBLEM LIKE THAT?

Thanks much, So this is for Oracle, I think something similar can be done on MS? (and without music-) Thanks much

Video s good but this damn stupid BG music is really distracting

Not able to understand the syntax.

No where on web I found such helpful fundamental description on hierarchy..!! Thank you 😊

What to do if you dont know the root? Can this be done in the same statement or should this be done in a seperate querry?

hi just inquiry can i use those functions in mysql and php?