2 ms·
^F case-insensitive search for: - cte - recursive - with (in SQL code, not prose) - connect (as in Oracle's CONNECT BY) nothing. Nothing! SQL deals
by cryptonector 1y ago
^F case-insensitive search for:
- cte
- recursive
- with (in SQL code, not prose)
- connect (as in Oracle's CONNECT BY)
nothing. Nothing!
SQL deals with hierarchical data just fine. You just have to learn about how (recursive CTEs).
- bwestergard 1y agoI've recently been learning about Datalog, which is excellent for all the queries that you'd want to do with recursive CTEs, but has the added benefit of making it much easier to factor one's code into discrete units (relations) for reusability.