blob: 0c863ad324723c604007bea19a1c123dacea6937 [file] [log] [blame]
SELECT
employee_id,
position_id,
sub,
FIRST_VALUE(sub) OVER(PARTITION BY position_id ORDER BY sub RANGE BETWEEN CURRENT ROW AND CURRENT ROW) AS `first_value`
FROM
%s