blob: 74726516d246f7447baa845f347a582599b5bd41 [file] [log] [blame]
SELECT
employee_id,
position_id,
sub,
FIRST_VALUE(sub) OVER(PARTITION BY position_id, sub) AS `first_value`
FROM
%s