Re: Incress Number

[Raphael ottiger]

Hello and thanks for your help.

Now I know how lag works.
But my problem is, that I creat an new row with the maximum values oft he day. How can I get this new row and creat an new row with the lag values? At the moment in my new created row with the lag values are only null values.


SELECT *, max(kilometers)
LAG(MeasurementKilometers. kilometers) over(PARTITION by Id Order by readDate) AS test
From `MeasurementKilometers`
where Id = 1
GROUP by ReadDate