YAM: Made Me Who I Am (Measureless 14/15)
Dr. Ernie
Walking the earth / Restoring the plants / Nurturing the soil / Healing the land…
tree
Recursive SQL queries over tree
Sergey Melnychuk
Some 10+ years ago on a job interview I was asked to query the database for the comments tree in a front-end friendly way, meaning no heavy processing/sorting to happen on the back-end. Turns out this question was to check if I knew about the Hierarchical Queries with Oracle (WITH RECURSIVE on...