hard20 pts · first answer countswindow-functionssqlgaps-and-islands

Runs of the same machine status

Statuses by minute are UP, UP, DOWN, DOWN, UP. You compute ROW_NUMBER() OVER (ORDER BY ts) - ROW_NUMBER() OVER (PARTITION BY status ORDER BY ts). What does grouping by status and this difference give?

A.Two groups: all UP rows and all DOWN rowsB.Five groups, one per rowC.Three runs: UP (2 rows), DOWN (2 rows), UP (1 row)D.Four groups, because the last UP is separate twice

Discussion 0

Join free to post in the discussion.

Runs of the same machine status

Discussion 0

Related questions