Top "Hierarchical-query" questions

Connect by in Oracle SQL

Suppose that we have following tables create table Employee( 2 EMPNO NUMBER(3), 3 ENAME VARCHAR2(15 BYTE), 4 HIREDATE DATE, 5 ORIG_SALARY NUMBER(6), 6 CURR_…

sql oracle hierarchical-query

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

I am trying and searching the way to get ALL last level children (leafs) from a node, in a hierchical …

sql oracle11g recursive-query hierarchical-query

Cycle detection with recursive subquery factoring

Oracle SQL can do hierarchical queries since v2, using their proprietary CONNECT BY syntax. In their latest 11g release 2, they …

sql oracle db2 hierarchical-query

Oracle CONNECT BY clause after GROUP BY clause

I have just run across this interesting article here, showing how to simulate wm_concat() or group_concat() in Oracle …

sql oracle select syntax hierarchical-query

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

Here's the full example data set for this query without any pruning of trees where no node matches the search …

oracle hierarchical-trees hierarchical-query

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

Does PostgreSQL have a pseudo-column like "LEVEL" in Oracle? If not, then how can we create a column similar to "…

oracle postgresql connect-by hierarchical-query recursive-cte