Re: LAG/LEAD function

[Peter Brawley]

Two syntax errors in the query you posted ...

SELECT 
  id,device_id, time,                     -- comma was missing after time
  LAG(time) OVER(W) AS 'lag', 
  time - LAG(time) OVER(W) as 'lag diff'  -- OVER(W) was missing after LAG(time)
FROM watchdog 
WINDOW W AS (ORDER BY time) ;