Doubt query oracle 11g

0

Good afternoon, I would like to create "Cycles" (Cycle field, increasing sequential numbering), where the beginning of the cycle will always be at "Cod = 10 (cod field)" and the End of Cycle "Cod 99 (Cod field)". In the case of End of Cycle if "Cod = 99" (in red) consider a single End. The "Accumulated Time" column should contain the sum of each Cycle.

Thanks in advance for your attention and collaboration.

    
asked by anonymous 27.10.2017 / 17:16

0 answers