• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1SELECT
2  ts,
3  lead(ts, 1, ts) OVER (PARTITION BY name ORDER BY ts) - ts AS dur,
4  value
5FROM counters
6WHERE ref = 1;
7