Statement for calculating the mileage generation time

Http://www.itpub.net/forum.php? MoD = viewthread & tid = 1711973 & page = 1

 

Actual Application statement:
Select lead (T. gpstime, 1) over (order by T. gpstime DESC) Start Time,
T. gpstime End Time,
Round (T.GPSTIME-LEAD (T. gpstime, 1) over (order by T. gpstime DESC) * 24*60) travel time,
Lead (T. Distance, 1) over (order by T. gpstime DESC) Start mileage,
T. Distance end mileage,
T.DISTANCE-LEAD (T. Distance, 1) over (order by T. gpstime DESC) mileage
From t_history t
Where T. gpstime between to_date ('1970-08-19 ', 'yyyy-MM-DD') and
To_date ('1970-08-20 ', 'yyyy-MM-DD ')
And T. unit_id = 87948
And T. Distance <> 0
Order by T. gpstime;