blob: 5d7eedd4d207664c5451ad91c0671320fcc40287 [file] [log] [blame]
SELECT
employee_id,
LAST_VALUE(employee_id) OVER(PARTITION BY position_id ORDER BY sub ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS `last_value`
FROM
%s