Outdated Version
You are viewing an older version of this section. View current production version.
LAST_VALUE
Value function. Returns an expression evaluated at the last row of the window frame. If there are no rows in the frame, returns NULL
.
For an overview of window functions in MemSQL, see Window Functions Guide.
Syntax
LAST_VALUE ( expression ) OVER (
[PARTITION BY (col | expr), ...]
[ORDER BY (col | expr), ...]
[frame_clause]
)
Arguments
- expression: any expression. This may be a column name, the result of another function, or a math operation.
Return Type
The result type of expression
Examples
memsql> create table example (a int, b int);
memsql> insert into example values(1, 2), (2, 2), (3, 3), (4, 3);
memsql> select a, last_value(a) over(order by (a)) from example;
+------+----------------------------------+
| a | last_value(a) over(order by (a)) |
+------+----------------------------------+
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
+------+----------------------------------+
memsql> select a, last_value(a) over(order by (a) rows between
current row and unbounded following) from example;
+------+-----------------------------------------------------------------------------------+
| a | last_value(a) over(order by (a) rows between current row and unbounded following) |
+------+-----------------------------------------------------------------------------------+
| 1 | 4 |
| 2 | 4 |
| 3 | 4 |
| 4 | 4 |
+------+-----------------------------------------------------------------------------------+