Get the Time Difference between records

Question

with this record on the TimeStamp I wish to extract the (time difference in seconds between the consecutive records) as another field name TimeDifference is that possible? how to modify the query? thanks. see below:

Prasenjit Dey · Answer

Hi Choose any one which you need select DATEDIFF ( day  2007 - 11 - 30  2007 - 11 - 20 ) AS NumberOfDays  DATEDIFF ( hour  2007 - 11 - 30  2007 - 11 - 20 ) AS NumberOfHours  DATEDIFF ( minute  2007 - 11 - 30  2007 - 11 - 20 ) AS NumberOfMinutes FROM test_table