StackOverflow Questions for Tag: hierarchical-query

user3016635
user3016635

Reputation: 27

Fastest response time to find all members of multi level many to many relationships and also the top most member of the hierarchy

Score: -4

Views: 48

Answers: 0

Read More
Leoncio Sobrino
Leoncio Sobrino

Reputation: 73

View to return the root node given any children (in Oracle)

Score: 0

Views: 95

Answers: 1

Read More
Matt Miles
Matt Miles

Reputation: 131

How to migrate Oracle's CONNECT_BY_ISLEAF, CONNECT_BY_ROOT, and CONNECT BY PRIOR to SQL Server?

Score: 0

Views: 44

Answers: 0

Read More
Velocity
Velocity

Reputation: 475

Oracle Apex tree child node returning multiple times

Score: 0

Views: 104

Answers: 1

Read More
r04dRunErr
r04dRunErr

Reputation: 53

Oracle hierarchical query joining 2 tables

Score: 2

Views: 41

Answers: 1

Read More
Anand Kulkarni
Anand Kulkarni

Reputation: 13

Is there Connect By Prior, connect_by_root & sys_connect_by_path function available in pyspark?

Score: 0

Views: 110

Answers: 0

Read More
Dmitry E.
Dmitry E.

Reputation: 103

What exactly does Oracle NOCYCLE parameter do in hierarchical queries?

Score: 1

Views: 2722

Answers: 1

Read More
TheDS
TheDS

Reputation: 101

Compute the child record value based on the parent value in Oracle PLSQL

Score: 0

Views: 58

Answers: 2

Read More
Neha
Neha

Reputation: 221

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

Score: 14

Views: 17892

Answers: 3

Read More
Zaoza14
Zaoza14

Reputation: 63

Add column with unique row value

Score: -1

Views: 51

Answers: 1

Read More
Pan Tomima
Pan Tomima

Reputation: 1

Hierarchical queries, is this example correct?

Score: 0

Views: 68

Answers: 0

Read More
themihai
themihai

Reputation: 8651

PostgreSQL Hierarchical, category tree

Score: 3

Views: 3292

Answers: 2

Read More
Yogus
Yogus

Reputation: 2272

Re-writting the query without "Connect By "

Score: 0

Views: 50

Answers: 1

Read More
Ghatothkachh
Ghatothkachh

Reputation: 21

How to insert a new row based on previous row

Score: 0

Views: 2664

Answers: 1

Read More
Beefstu
Beefstu

Reputation: 857

Oracle Oracle hierarchical query to disable foreign keys

Score: 0

Views: 315

Answers: 2

Read More
Vicki
Vicki

Reputation: 43

Oracle Hierarchical Query at depth level

Score: 1

Views: 411

Answers: 3

Read More
Burak Kartal
Burak Kartal

Reputation: 41

Oracle Start With In Limit

Score: 0

Views: 55

Answers: 0

Read More
Enxhi
Enxhi

Reputation: 1

Hierarchy formatting

Score: 0

Views: 60

Answers: 2

Read More
AsfK
AsfK

Reputation: 3476

SQL syntax for update query with connect by prior

Score: 4

Views: 2670

Answers: 2

Read More
a.d
a.d

Reputation: 3

Oracle SQL hierarical query connected by sequential field

Score: 0

Views: 66

Answers: 1

Read More
PreviousPage 1Next