Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in hierarchical-query

PostgreSQL Hierarchical, category tree

Hierarchical SQL Queries: Best SQL query to obtain the whole branch of a tree from a [nodeid, parentid] pairs table given the end node id

Need an Oracle hierarchical query that returns only full trees for records where children match a search string

Oracle SQL start with/prior

How to do WHERE-CLAUSE in hierarchical query in Oracle

Why does Oracle pseudo column CONNECT_BY_ISLEAF seems broken?

get ALL last level children (leafs) from a node (hierarhical queries Oracle 11G)

Oracle CONNECT BY clause after GROUP BY clause

Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle?

Connect by in Oracle SQL

How to traverse a hierarchical tree-structure structure backwards using recursive queries

Cycle detection with recursive subquery factoring