INSERT INTO MYTABLE_TEST VALUES (
    'USER1',
    '11'
);

INSERT INTO MYTABLE_TEST VALUES (
    'USER2',
    '21'
);

INSERT INTO MYTABLE_TEST VALUES (
    'USER2',
    '22'
);

INSERT INTO MYTABLE_TEST VALUES (
    'USER3',
    '31'
);

INSERT INTO MYTABLE_TEST VALUES (
    'USER3',
    '32'
);

INSERT INTO MYTABLE_TEST VALUES (
    'USER3',
    '33'
);

SELECT * FROM MYTABLE_TEST;

SELECT
    NAME,
    VAL
FROM
    (
        SELECT
            NAME,
            VAL,
            ROW_NUMBER() OVER(
                PARTITION BY NAME
                ORDER BY
                    VAL DESC NULLS LAST
            ) RN
        FROM
            MYTABLE_TEST T
    )
WHERE
    RN = 1;