I want to calculate machine mode time range from this table. How can I write a SQL query for this situation?

Question

enter image description here

I could not add image

Answer 1

You can try do something like this:

Select machinestate, 
Lead(machinestate,1) OVER (PARTITION BY machinename ORDER BY time) as 
         next_machinestate, 
Lead(time,1) OVER (PARTITION BY machinename ORDER BY time) - time as 
         time_range 
from your_table