Untitled

UPDATE
    res_partner AS rp
SET
    v14_id = (
        CASE
            WHEN sq.ligne = 1 THEN rp.v14_id
            ELSE 0
        END
    ),
    write_date = '2022-09-30 09:15:52.023467'
FROM(
    SELECT
        A.id,
        B.v14_id,
        B.ligne,
        B.cnt,
        A.name
    FROM
        res_partner AS A
        INNER JOIN(
            SELECT
                id,
                name,
                v14_id,
                ROW_NUMBER() OVER (PARTITION BY v14_id ORDER BY write_date) AS ligne,
                COUNT(v14_id) OVER (PARTITION BY v14_id) AS cnt
           FROM
               res_partner
           WHERE
               v14_id != 0) AS B ON A.id = B.id
    WHERE
        B.cnt > 1) AS sq
WHERE
    rp.id = sq.id;