SQLize Online / PHPize Online  /  SQLtest Online

WITH t(date, user1, value) AS ( SELECT 1, 1, 4 UNION ALL SELECT 2, 1, 3 UNION ALL SELECT 3, 1, 5 UNION ALL SELECT 4, 1, null UNION ALL SELECT 5, 1, NULL UNION ALL SELECT 2, 2, 3 UNION ALL SELECT 4, 2, 2 UNION ALL SELECT 5, 2, NULL UNION ALL SELECT 7, 3, NULL UNION ALL SELECT 8, 3, NULL UNION ALL SELECT 9, 4, 4 UNION ALL SELECT 11, 4, 3 ) SELECT date, user1, value, last_value(value) IGNORE NULLS OVER (PARTITION BY user1 ORDER BY date asc ) AS value1 FROM t