FunctionsWindow
first_value
Returns the value of an expression from the first row of the current window frame.
first_value(…) → DynamicKind · window
Returns the value of an expression from the first row of the current window frame.
Part of the Window family.
dense_rank
Returns the rank of the current row within its partition; ties receive the same rank and ranks increase by 1 for each distinct ORDER BY value.
lag
Returns the value of an expression evaluated on a row that is a given number of rows before the current row within the window partition. An optional default is returned when the offset is out of ra…