SQL Language (MOSC)

MOSC Banner

Connect by prior on rows that have the same timestamp group

in SQL Language (MOSC) 6 commentsAnswered

Hi,

I have a table with different timestamps and each timestamp has a few rows. I want to do a connnect by prior where each connect by prior group is separated by a timestamp . I can select a timestamp that returns e.g. 10 rows and do a connect by prior on these rows, but I have no idea how to do it with all these timestamp groups and get all of them ordered as output back?

Any help is appreciated.

thx t-1000

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center