Нумерация в рамках группировки

 WITH NumberedRows AS (
    SELECT
        EMPL_CODE,
        ID,
        DATE_FROM,
        ROW_NUMBER() OVER (PARTITION BY EMPL_CODE ORDER BY DATE_FROM) AS RowNum
    FROM
        RFH2B
)
UPDATE NumberedRows
SET ID = RowNum;