SELECT *,
last_value(col1) OVER (PARTITION BY
col_x_date ORDER
BY date
RANGE BETWEEN
UNBOUNDED PRECEDING AND
UNBOUNDED FOLLOWING) AS
cdata FROM
table;
| LastValue_Preceeding1.htm |
| Oracle example Only: ( |
| Rule:
|
| SELECT ename,empno, sal, hiredate as hrd, LAST_VALUE(hiredate) OVER (ORDER BY sal ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS lv FROM (SELECT * FROM emp WHERE deptno in (10, 30) ORDER BY hiredate) |
| Oracle:
|