ENTIME on how to achieve the next row minus one line? Reached a value that is less than 1 second?

CodePudding user response:

Database is not "on line", the concept of "the next line", if any, is sorted order, do you want to find out the time interval is less than 1 second record?

CodePudding user response:

The following statement query under "a" minus "on a" time lag (by entime sorting), field for time2, units for the day:
Select *,
Cast (entime - (select top 1 entime from enpass where entime & lt;=a.e ntime order by entime) as float) as time2
The from enpass a.