Count a result for 2 rows one under other

Question

How can I add another column where will be the difference between 2nd and 3rd row, than the 3rd and the 4th and so on. Thanks in advance!

Is this the sort of thing you mean: http://stackoverflow.com/questions/634568/how-to-get-difference-between-two-rows-for-a-column-field — Paul Michaels, Oct 18 '16 at 19:27

score 2 · Answer 1 · answered Oct 18 '16 at 19:36

2

Use lag():

select d.*,
       (department_id - lag(department_id) over (order by department_id)) as diff
from departments d;

answered Oct 18 '16 at 19:36

Gordon Linoff

1 Answers1