How to compare rows of your datatable?

Asked Nov 08 '22 at 13:19

Active Nov 08 '22 at 13:19

Viewed 18 times

Asuming the table is ordered, Im looking for a resultset that gives me the difference of value in row x and value in row (x + 1)

I can make a condition for value_rowx and one for value_rowx+1 then self join those so I actually subtract columns not rows.

asked Nov 08 '22 at 13:19

Look into window functions like LAG en LEAD – Wouter Nov 08 '22 at 13:22
2

'Asuming the table is ordered' - that's a poor start , tables aren't ordered...and what equates to row x in your table? – P.Salmon Nov 08 '22 at 13:23
Think of a table as a drawer full of socks. In your table, "row x" has no meaning unless there is some data in the table that gives it meaning. – Stuck at 1337 Nov 08 '22 at 13:32
You could improve this question bye adding table definition, sample data and expected outcome as text. – P.Salmon Nov 08 '22 at 13:47

0 Answers0