SQL Lessons: Hierarchical (Recursive) Queries / Ilya Khokhlov
When constructing SQL queries, you may sometimes need to join a table to itself. If a table contains a list of employees with job titles, or, for example, branches and their sub-branches, you can display the entire hierarchy in a single query, adding just a few words! This lesson discusses hierarchical (recursive) queries.
You can download the practice SQL file for this lesson at:
https://prime-soft.biz/std/sql/hierar...
Thank you for your attention! Please leave your comments below the video!
#SQL #Databases #ORACLE