Skip to content

Instantly share code, notes, and snippets.

@llCorvinSll
Created March 25, 2015 12:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save llCorvinSll/31f551bbaa959426fff0 to your computer and use it in GitHub Desktop.
Save llCorvinSll/31f551bbaa959426fff0 to your computer and use it in GitHub Desktop.
T-SQL LEAD() example select rows with time interval between more then 1 hour
select *, DATEDIFF(second,StartTime,NextStart) from (SELECT data.Id, data.RawValue, data.RawName, data.StartTime, LEAD(data.StartTime) OVER (ORDER BY data.StartTime) NextStart, data.EndTime FROM [UsageEventDatas] as data where data.ObjectId = '00000000-0000-0000-0000-000000000000' and data.RawName LIKE 'CPUPercentUtilization-A%' and data.StartTime > CONVERT(datetime, '2015-02-27') and data.EndTime < CONVERT(datetime, '2015-03-01') ) as data where DATEDIFF(second,StartTime,NextStart) > 3600
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment