Compute Time Difference in Teradata

[iceman23]

Hello,

My question in teradata would be, will it be possible to get the time difference of 2 given date/time, given that the first value of the would be the 1st row of 2nd column then the second value would be the 2nd row of 1st column.

You may check the attachment.

Thanks in advance.

[amitpatel66]

Check LEAD AND LAG to achieve your result