Спринт 6/12 → Тема 2/5: Аналитические СУБД. Vertica → Урок 11/14 → Задание 3

MERGE INTO members tgt
USING
    SELECT
        id, age, gender, email
    FROM
        members_inc src
ON
    tgt.id = src.id
WHEN MATCHED and (
        age <> src.age
        or gender <> src.gender
        or email <> src.email
)
    THEN UPDATE SET
                age = src.age,
                gender = src.gender,
                email = src.email
WHEN NOT MATCHED
    THEN INSERT (
                id,
                age,
                gender,
                email
        )
    VALUES (
                src.id,
                src.age,
                src.gender,
                src.email
        );