Next Job Start Time with Previous Job Complete Time

[Waqas ali]

Dear All,

i want to write a query to get next record StartJob time with previous End Job Time how should i write a query?
data is in same table.

Machine	StartJob	EndJob	Next Record Start Time
A	29/09/2015 06:40	29/09/2015 06:41	29/09/2015 06:42
A	29/09/2015 06:42	29/09/2015 06:43
A	29/09/2015 06:44	29/09/2015 06:44

<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[HiTechCoach]

Dear All,

i want to write a query to get next record StartJob time with previous End Job Time how should i write a query?
data is in same table.

Machine	StartJob	EndJob	Next Record Start Time
A	29/09/2015 06:40	29/09/2015 06:41	29/09/2015 06:42
A	29/09/2015 06:42	29/09/2015 06:43
A	29/09/2015 06:44	29/09/2015 06:44

<tbody>
</tbody>

I would use a sub query. See: Subquery basics