SQL End Time as start Time

Question

I have an Table containing data's as follows,

I want them to be seperated as Start Time and End time where the Start and end are same for first row while second row start time is first row End time.

Answer 1

You want lag():

select t.*,
       lag(time, 1, time) over (order by time) as starttime,
       time as endtime
from t;