A function that partitions a result set and computes something within that partition without rolling up the data in that partition.

learn more… | top users | synonyms

1
vote
1answer
32 views

Calculate value differences of rows before and after bounded by multiple referenced rows

Supposed I have a user travelling table like this: id | start_time | end_time | location | ----+--------------+------------+------------+ 1 | 1 | 2 | Loc_A | 1 | ...