Tag: hierarchy

Oracle Hierarchy – How to get a particular level record in a query?

We have the following structure for Organizations. Query returns the result What I’m trying to do is let’s say I need to get the Department (Information Technology Department) of org_id 4 (Database Unit), how should I build the query for that? Currently we built a function that returns the departm…

Hierarchy Queries in BigQuery

google-bigquery hierarchy sql

I have a data from ControlM (scheduler) this way I saw many solutions where they have started from first node and descended to last node. But that is likely to fan-out with this data. What I am looking for a fan-in solution, where I can start with any end node and come towards first node In this case the answ…

Assigning a HANA hierarchy query to a table variable leads to inconsistent results

function hana hierarchy sql

Context I want to use the HANA HIERARCHY_TEMPORAL function to work on a SAP KNVH hierarchy with time intervals ; When simply used in a SELECT query, this works fine ; When otherwise using the very same query but assigning it to a table variable, the result is inconsistent. My problem This anonymous block work…

Make parent and child hierarchy with records for parents as well as children

hierarchy parent-child sql teradata

I have a parent-child id_table hierarchy – e.g. |parent|child| |——|—–| | | 0| | 0| 1| | 0| 2| | 0| 3| | 1| 4| | 1| 5| | 2| 6| | 4| 7| | …

Query with hierarchical structure and variable number of hierarchy levels

hierarchy sql sql-server

I have table ‘Areas’ containing customer’s areas: ID, AREA_NAME, PARENT_ID Areas are organized in hierarchy up to four levels using PARENT_ID pointing to parent’s AREA_ID. PARENT_ID for top level …

CTE or not for counting tree id’s referenced in secondary table

hierarchical-data hierarchy sql sql-server

I have a simple tree table in which I reference types, sub-types (no level limit), brands and models for a simple inventory application. data structure is as shown below: (nodeIsModel is a boolean …

How to flatten parent-child hierarchy from bottom up using CTE

common-table-expression hierarchy sql sql-server

for my first question on stack overflow I have the following problem, I’ve got an hierarchy table that looks as follows: The data looks as follows: the row with the wbe_node_type ‘leaf’ is the lowest level in the hierarchy, maximum depth is 8 levels deep. What I want is to flatten the hierar…