Other Functions
ROW_NUMBER
ROW_NUMBER() OVER()
Description:
Assign a sequential integer to each row as a row number. The row number starts from 1.
Example
Result:
row_number
1
2
3
LAG
LAG(column1, [n_lags]) OVER(ORDER BY column2)
Description
Move each value in column1 forward to the next row. The table will be ordered by column2 first before values are moved. If n_lags is specified, each value is shifted to the next n_lags rows. The first n_lags values will be NULL.
Example
Result:
date
price
price_lag
12-11
30
NULL
12-12
32
30
12-13
28
32
Last updated