SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need SQL Query to get time intervals

ursveeraAug 16 2022 — edited Aug 16 2022

Hi,
I need help in query to get intervals of event and timestamp combination (even if there is a gap of 1 second, we need an additional interval). below are the sample data and expected results.
Input
--------------------------------------

And the expected Output is

Thanks,
Veera

Added on Aug 16 2022

7 comments

254 views

1 mention